Data Modeling, A Beginner's Guide

Chapter 7Beyond Third Normal Form

Key Skills & Concepts

• Boyce-Codd Normal Form

• Fourth Normal Form

• Fifth Normal Form

• Domain Key Normal Form

• Resolving Supertypes and Subtypes

• Generalizing Attributes

• Alternatives for Reference Data

This chapter addresses additional considerations not covered by third normal form. While third normal form resolves most of the anomalies found in business systems, there can be other issues. The section “Advanced Normalization” covers normalization forms designed to mitigate anomalies that are sometimes found in entities that are already in third normal form, including Boyce-Codd normal form, fourth normal form, fifth normal form, and domain key normal form. The section “Resolving Supertypes and Subtypes” ...