Module
Functional Dependencies and Normalization
Sign in to add this module to your path and practice.
About
Functional dependencies, attribute closure, canonical covers, lossless-join and dependency-preserving decompositions, normal forms (1NF–BCNF, 3NF synthesis, overview of 4NF/MVDs). Practical schema refinement and trade-offs with denormalization.
Goal
Given a set of FDs, compute closures, determine the highest normal form of a relation, and produce a BCNF or 3NF decomposition that is lossless and (when possible) dependency-preserving; justify design choices.
Unlocks
Tutor
Ask questions about this module.
Hi — I'm your tutor for Functional Dependencies and Normalization. Ask about the concepts, goal, or where you're stuck.