In this chapter, you will learn about:
• Data integrity
• Primary and foreign keys
• Normalization and denormalization
• Using defaults with null
• Partitioning tables via horizontal partitioning or partition schemes
• Database design and database diagrams
Think simple as my old master used to say—meaning reduce the whole of its parts into the simplest terms, getting back to first principles.
—Frank Lloyd Wright
There's a lot to be said for Frank Lloyd Wright's philosophy. Simple can be beautiful. We can apply his idea to architecture as he did in creating his masterpieces. Or we can apply it to databases, creating highly efficient data stores.
In the last chapter, we covered data types and ...