Lesson 6 of 16 • 17 upvotes • 11:07mins
In this lesson, we will see the types of Functional dependencies and we will also see the inference rules to be used to solve the numerical on Functional dependencies!
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