CHAPTER 

6

Normalization and Denormalization

TABLE OF CONTENTS

6.1    Objectives of Normalization

6.2    Insertion, Update, and Deletion Anomalies

6.3    Functional Dependency

6.4    Superkeys, Candidate Keys, and Primary Keys

6.5    Normalization Using Primary Keys

6.6    Properties of Relational Decompositions

6.7    The Normalization Process

6.8    When to Stop Normalizing

6.9    Non-normalized Databases

6.10  Chapter Summary

Exercises

CHAPTER OBJECTIVES

In this chapter you will learn the following:

  Objectives of normalization

  The meaning of update, insertion, and deletion anomalies

  The meaning of functional dependency and its relationship to keys

  The meaning of full functional dependency and transitive dependency

  The definitions ...

Get Databases Illuminated, 3rd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.