CIS 515 Week 4 Discussion Questions

CIS 515 Week 4 Discussion Question 1

"Optimizing Database Design" Please respond to the following:

• Many legacy systems require normalization. Identify at least two factors that should be considered in order to produce an optimal normalized set of tables when performing normalization. Include in your discussion a detailed example on how each factor would eliminate data redundancy.
• Optimal database design recognizes proper organization of table structures and relationships. Suggest at least two methods that can be used to improve the design of a database system.

http://hwacer.com/Tutorial/cis-515-week-4-discussion-questions/

CIS 515 Week 4 Discussion Question 2

 "Denormalization Functionality" Please respond to the following:

• Having an adequate data model to serve specific business needs of an organization is important. Evaluate the need for denormalization within an organization. Provide at least three examples that prove denormalization is useful to data consumers.
• Using a data-modeling checklist can help database developers design efficient data repositories. Suggest at least two possible scenarios that could take place if one of the steps in the data-modeling checklist (table 6.7 in Chapter 6 of the textbook) is missed.

HSA 505 Week 3 Assignment 1, HSA 505 Assignment 1, HSA 510 Week 10. ECE 430 Week 2 Journal, ECE 430 Week 2 Discussion, ECE 430 Week 3 Discussion, ECE 430 WEEK 3 JOURNAL, ECE 430 Week 4 Assignment Informal Assessment Presentation, ECE 430 Week 4 Assignment, ECE 430 Week 4 Discussion, CIS 599 Week 11 Discussion 1, ECE 430 FINAL PROJECT,  ECE 430 Week 5 Discussion, CIS 512 Week 8 Discussion, CIS 512 Week 9 Discussion, CIS 505 Week 3 Discussion, CIS 505 Week 3 Discussion 1, CIS 505 Week 3 Discussion 2, CIS 505 Week 8 Assignment 4, CIS 505 Assignment 4, CIS 505 Week 8 Discussion, CIS 505 Week 8 Discussion 1, CIS 505 Week 8 Discussion 2, CIS 599 Week 11 Discussion 2,  HSA 505 Week 4 Case study 1, HSA 505 Case study 1,  CIS 505 Week 9 Assignment 5, CIS 505 Assignment 5, CIS 505 Week 9 Discussion, CIS 505 Week 9 Discussion 1, CIS 512 Week 10 Term Paper Virtualization, CIS 512 Week 10 Term Paper, CIS 515 Week 4 Discussion Questions, CIS 515 Week 4 Discussion 1, HSA 505 Case study 1,  CIS 505 Week 9 Assignment 5, CIS 505 Assignment 5, CIS 505 Week 9 Discussion, CIS 505 Week 9 Discussion 1, CIS 512 Week 10 Term Paper Virtualization, CIS 512 Week 10 Term Paper, CIS 515 Week 4 Discussion Questions, CIS 515 Week 4 Discussion 1