Chapter 8: Database Normalization - Mastering MySQL 4 [Electronic resources] نسخه متنی

Chapter 8: Database Normalization

Overview

This chapter introduces you to a powerful tool for optimizing your database design: normalization. Developed in the 1970s by E.F. Codd, normalization is now a standard requirement of most database designs. By following the steps outlined in this chapter, you'll be able to reduce data anomalies and ease maintenance.

Featured in this chapter:

1st normal form

2nd normal form

3rd normal form

Boyce-Codd normal form

4th normal form

5th normal form

Denormalization