MCITP SQL Server 2005 Database Administration All-in-One Exam Guide (Exams 70-431, 70-443, & 70-444)

CHAPTER 3 Database Design

In this chapter, you will learn about:

• Data integrity

• Primary and foreign keys

• Normalization and denormalization

• Constraints

• Using defaults with null

• Checks

• 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 ...