Relational Database Design & Normalization

Video Lessons & Revision Notes

Relational Design - Purpose of Normalization
Relational Design - Purpose of Normalization
1. Relational Design - Purpose of Normalization
In this 43 mins Video Lesson
Introduction, Normalization, Purpose of Normalization, Updation Anomalies, Deletion Aomalies, NULL values, Lossy Decompostion, and other topics.
Functional Dependency, Armstrong’s Axioms and Closure
Functional Dependency, Armstrong’s Axioms and Closure
2. Functional Dependency, Armstrong’s Axioms and Closure
In this 44 mins Video Lesson
Functional Dependency, Trivial FD, Closure Of set of FDs, Armstrong's Axioms, Closure: Algorithm, and other topics.
Closure of Attribute Set, Equivalence of FDs and Introduction to Canonical Cover
Closure of Attribute Set, Equivalence of FDs and Introduction to Canonical Cover
3. Closure of Attribute Set, Equivalence of FDs and Introduction to Canonical Cover
In this 39 mins Video Lesson
Closure of an attribute Set, Uses of Clossure of Attribute Set, Closure of Attribute Set: Algorithm, Equivalence of FDs, Canonical Cover, Extraneous Attributes, and other topics.
Canonical Cover and Decomposition
Canonical Cover and Decomposition
4. Canonical Cover and Decomposition
In this 35 mins Video Lesson
Canonical Cover: Definition, Canonical Cover: Algorithm, Decomposition, Lossless Join Decomposition, Dependency Presevation Property, Dependency Preservation: Algorithm, and other topics.
Normalization - 1NF, Full Functional Dependency and 2NF
Normalization - 1NF, Full Functional Dependency and 2NF
5. Normalization - 1NF, Full Functional Dependency and 2NF
In this 46 mins Video Lesson
Introduction, 1NF, Prime Attribute, Full Functional Dependency, 2NF, Transitive Dependency, and other topics.
Normalization - 3NF, BCNF, Multivalued Dependency, 4NF and 5NF
Normalization - 3NF, BCNF, Multivalued Dependency, 4NF and 5NF
6. Normalization - 3NF, BCNF, Multivalued Dependency, 4NF and 5NF
In this 50 mins Video Lesson
3NF: Illustration, BCNF, Multivalued Dependency, 4NF, 5NF, and other topics.

Revision Notes

Normal Forms (1.95 Mb)

Purpose of Normalization, Data Redundancy and Update Anomalies, Functional Dependencies: Basic concepts, closure of set of functional dependencies, closure of attribute set, canonical cover, Decomposition: lossless join decomposition and dependency preservation, The Process of Normalization: 1NF, 2NF, 3NF, BCNF, 4NF, 5NF

Member's Zone