What are the key issues in deciding between using perfectly

What are the key issues in deciding between using perfectly normalized databases and denormalized databases? Describe three situations that can be good candidates for denormalization.

Solution

What are the key issues in deciding between using perfectly normalized databases and denormalized databases?I

it is better if you use normalized files because there are directly mapped to problemdomain ententies, they are less redundant and more maintaninable.

On the other hand denormalized data base can improve performance when updading changes are not needed.

Describe three situations that can be good candidates for denormalization.

Denormilzation is performed to speed up data access. Normalized order table, the customer name will not be lincluded.

A lookup table of zip codes and states that may be set up in the normalized data model but could be added back into the physical model design.

Table of product codes listing the desciption and price.