Chapter 14 Advanced Normalization Transparencies by Carolyn E. Begg, Thomas Connolly
- How inference rules can identify a set of all functional dependencies for a relation.
- How Inference rules called Armstrong’s axioms can identify a minimal set of useful functional dependencies from the set of all functional dependencies for a relation.
- Normal forms that go beyond Third Normal Form (3NF), which includes Boyce-Codd Normal Form (BCNF), Fourth Normal Form (4NF), and Fifth Normal Form (5NF).
- How to identify Boyce–Codd Normal Form (BCNF).
- How to represent attributes shown on a report as BCNF relations using normalization.
- Concept of multi-valued dependencies and Fourth Normal Form (4NF).
- The problems associated with relations that break the rules of 4NF.
- How to create 4NF relations from a relation, which breaks the rules of to 4NF.
- Concept of join dependency and Fifth Normal Form (5NF).
- The problems associated with relations that break the rules of 5NF.
- How to create 5NF relations from a relation, which breaks the rules of 5NF.