Week 7 CIS 515

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.

 Recall that a recursive relationship occurs when an entity is involved in a relationship with itself. Figure 6-7 illustrates a recursive relationship.