Lesson 15 of 16 • 13 upvotes • 13:23mins
In this lesson we will see the lossless join decomposition and we will also see some practice questions to see this topic in detail.
16 lessons • 3h 35m
Course Overview (in Hindi)
12:48mins
Three - Tier Schema (in Hindi)
14:37mins
Introduction to DBMS (in Hindi)
13:48mins
Database Design Techniques (in Hindi)
12:09mins
Introduction to Functional Dependency (in Hindi)
13:48mins
Types of FD and inference rules (in Hindi)
11:07mins
Finding Closure of Attributes
13:28mins
Membership Test for FD
12:42mins
Equivalence of set of Functional Dependencies
12:53mins
Canonical Cover of set of Functional dependencies
14:24mins
How to find the Candidate Key
13:23mins
2NF and 3NF
13:59mins
Normalization and 1NF
14:14mins
BCNF & Practice Questions on Normalization
14:34mins
Lossless Join Decomposition
13:23mins
Dependency Preserving Decomposition
13:42mins