SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond

Summary

In this chapter, you learned about the final and certainly very important database-design concept of normalization. In the end, normalization is mostly about eradicating redundancies; however, the principles used to get there are actually focused on removing the likelihood of write anomalies. Write anomalies usually result in bad or missing data, and that's never good for any database.

You learned about the different levels of normalization that are commonly defined in the database design knowledge domain. With each level, you explored how to achieve it in a given database. To make the process as easy for you as possible, you stepped through converting a flat, denormalized Excel worksheet into a normalized database table.

Finally, you ...