Chapter 4. Database Design Continued: An Introduction to Normalization
CHAPTER HIGHLIGHTS:
Denormalize Data—When Does It Make Sense to Break the Rules?
Normalization Applied—Review the TEB Database and Refine the Design
In the last chapter, you were introduced to basic database design concepts. In this chapter, you will build on those skills. If you recall one of the basic mantras of this book, it takes several iterations of work to reach an optimal database design. After your initial complement of tables has been created, the next step involves outfitting the tables with columns. At this point, the only columns that exist are the primary and foreign ...
Get Absolute Beginner’s Guide to Databases 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.
