Absolute Beginner’s Guide to Databases

What You Have Learned

In this Chapter, you have been introduced to the concepts of normalization and the impact normalization has on database design. In most situations, a database needs to conform only to the third normal form. In some situations, however, the fourth and fifth normal forms are required. As you go through the process of normalization, you will be able to formulate which columns have to be stored in which tables. It is almost certain that your normalization efforts will lead to a few new tables that were not contemplated in your initial design efforts. This chapter and the previous chapter have outlined a roadmap and framework for conducting database analysis and design. Database analysis and design can be a complex area, so ...