Relational Database Design and Implementation, 4th Edition

Chapter 7

Normalization

Abstract

This chapter covers the process of transforming an ER diagram into a well-designed relational database. For each normal norm, the chapter presents the rules that relations must meet to reach that normal form, and the design problems that may remain. It also covers the process for transforming relations into higher normal forms, including relational algebra operations, where appropriate.

Keywords

normalization

normal forms

database normalization

first normal form

second normal form

third normal form

fourth normal form

fifth normal form

sixth normal form

domain-key normal form

Boyce–Codd normal form

relational database design

Given any pool of entities and attributes, there is a large number of ways you can group them ...