Functional Dependency, Armstrong’s Axioms and Closure
Loading Video Lesson
If you dont see the Video even after 10 seconds,
then please download and Install the Flash Player
In this 44 mins Lesson you will Learn about following concepts.
Functional Dependency, Trivial FD, Closure Of set of FDs, Armstrong's Axioms, Closure: Algorithm, and related Topics.
Related Video Lessons in this Series
Relational Design - Purpose of Normalization
43 mins Video LessonIntroduction, Normalization, Purpose of Normalization, Updation Anomalies, Deletion Aomalies, NULL values, Lossy Decompostion, and other topics.
Functional Dependency, Armstrong’s Axioms and Closure
44 mins Video LessonFunctional 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
39 mins Video LessonClosure 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
35 mins Video LessonCanonical 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
46 mins Video LessonIntroduction, 1NF, Prime Attribute, Full Functional Dependency, 2NF, Transitive Dependency, and other topics.
.jpg)
Normalization - 3NF, BCNF, Multivalued Dependency, 4NF and 5NF
50 mins Video Lesson3NF: Illustration, BCNF, Multivalued Dependency, 4NF, 5NF, and other topics.
Distributed Database - Basic Concepts, Fragmentation and Allocation
54 mins Video LessonDistributed Computing System, Distributed DB, Distributed Database, Advantages of DDBMS, Special Functions of DDBMS, Fragmentation, Horizontal, Vertical, Mixed/ Hybrid Fragmentation, Fragmentation Schema, Allocation, Allocation Schema, and other topics.
Distributed Database - Replication, Query Processing and Concurrency Control
50 mins Video LessonIntroduction, Data Replication, Query Processing, Semi Join, Concurrency Control, Distinguish Copy Techniques, Primary Site, Primary Site with Backup, Primary Copy Technique, Selecting a Co-ordinator , Voting Based Techniques, and other topics.
