Sams Teach Yourself SQL in 24 Hours, Third Edition By Ronald R. Plew, Ryan K. Stephens
Table of Contents
Hour 4. The Normalization Process
Q&A
Q1:
Why should I be so concerned with the end user 's needs when designing the database?
A1:
The end users are the real data experts who use the database, and, in that respect, they should be the focus of any database design effort. The database designer only helps organize the data.
Q2:
It seems to me that normalization is more advantageous than denormalization. Do you agree?
A2:
It can be more advantageous. However, denormalization, to a point, could be more advantageous. Remember, there are many factors that help determine which way to go. You will probably normalize your database to reduce repetition in the database, but may turn around and denormalize to a certain extent to improve performance.
