Java Script needs to be enabled for Video to Load.

Normalization - 1NF, Full Functional Dependency and 2NF

Loading Video Lesson

If you dont see the Video even after 10 seconds,
then please download and Install the Flash Player


In this 46 mins Lesson you will Learn about following concepts.
Normalization - 1NF, Full Functional Dependency and 2NF

Introduction, 1NF, Prime Attribute, Full Functional Dependency, 2NF, Transitive Dependency, and related Topics.


Related Video Lessons in this Series

Relational Design - Purpose of Normalization

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

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

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

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

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

50 mins Video Lesson

3NF: Illustration, BCNF, Multivalued Dependency, 4NF, 5NF, and other topics.

Distributed Database - Basic Concepts, Fragmentation and Allocation

54 mins Video Lesson

Distributed 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 Lesson

Introduction, 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.

Member's Zone