October 2002
Beginner
864 pages
18h 41m
English
| Q1: | Why should I be so concerned with the end users' needs when designing the database? |
| A1: | The end users are the real experts of the data and are the people who will be using the database, and in that respect, should be the main focus of any database design effort. The database designer only helps to organize the data. |
| Q2: | It seems to me that normalization is more advantageous than denormalization. Do you agree? |
| A2: | Well, yes, it can be more advantageous; however, denormalization to a point can be more advantageous. Remember, there are many factors that help to determine which way to go, as discussed today. You will probably normalize your database to reduce repetition, but may turn around and denormalize to a certain extent to improve performance. ... |
Read now
Unlock full access