O'Reilly logo

MCITP SQL Server 2005 Database Administration All-in-One exam Guide by Darril Gibson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required