Java Script needs to be enabled for Video to Load.

# Normalization - 3NF, BCNF, Multivalued Dependency, 4NF and 5NF

If you dont see the Video even after 10 seconds,

##### In this 50 mins Lesson you will Learn about following concepts.

3NF: Illustration, BCNF, Multivalued Dependency, 4NF, 5NF, 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.