CHAPTER 3Database Design
In this chapter, you will learn about:
• Data integrity
• PRIMARY and FOREIGN KEY constraints
• Normalization and denormalization
• CHECK constraints
• Partitioning tables via horizontal partitioning or partition schemes
• Database design through an exercise
Beauty of style and harmony and grace and good rhythm depend on simplicity.
Simplicity. No matter what you're designing—from a graceful garden to a dynamic database—much of the beauty comes from the simplicity of the design. In databases, we achieve simplicity by normalizing a database.
In Chapter 2, we presented basic data types and tables. In this chapter, we'll add multiple tables and show how the tables can be related with PRIMARY and FOREIGN KEYs. ...