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. |
Get Sams Teach Yourself SQL in 24 Hours, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
