WIKIPEDIA STUFF Functional dependencies How to test lossless join Ch10 Measures for quality of relational design - Clear semantics of attributes Reundant information and update anomolies NULL values Generation of spurious tuples Functional Dependencies - Inference rules Closure of attributes under functional dependencies Cover of functional dependencies Minimal cover Normalizaton HOW DO I ACHIEVE 1NF? Superkey, candidate key, primary key, secondary key Prime attribute, non-prime attribute First normal forms Second normal forms and partial dependencies Third normal forms and transitive dependencies Boyce-Codd normal forms Ch11 Properties of relational decomposition Lossless join, how to test this? Dependency preservation How to decompse a relation into 3NF with the lossless join and dependency-preservation properties? Algorithm exists, starts with minimal cover How to decompose a relation into BCNF with lossless join property? Pretty much same algorithm Transitive functional dependency