Please Login To Continue
Dependency Preserving Decomposition
Lesson 16 of 16 • 20 upvotes • 13:42mins
Danish Aggarwal
In this lesson, we will see how to find dependency preserving decomposition for a given relation. We will discuss one ESE PYQ here also.In the end, there is a practice question also.
(Hindi) Functional Dependencies And Normalization: ESE - E&T Engineering
16 lessons • 3h 35m
1
Course Overview (in Hindi)
12:48mins
2
Three - Tier Schema (in Hindi)
14:37mins
3
Introduction to DBMS (in Hindi)
13:48mins
4
Database Design Techniques (in Hindi)
12:09mins
5
Introduction to Functional Dependency (in Hindi)
13:48mins
6
Types of FD and inference rules (in Hindi)
11:07mins
7
Finding Closure of Attributes
13:28mins
8
Membership Test for FD
12:42mins
9
Equivalence of set of Functional Dependencies
12:53mins
10
Canonical Cover of set of Functional dependencies
14:24mins
11
How to find the Candidate Key
13:23mins
12
2NF and 3NF
13:59mins
13
Normalization and 1NF
14:14mins
14
BCNF & Practice Questions on Normalization
14:34mins
15
Lossless Join Decomposition
13:23mins
16
Dependency Preserving Decomposition
13:42mins
Crack GATE - Iconic Pro with Unacademy
Get subscription and access unlimited live and recorded courses from India's best educators
Structured syllabus
Daily live classes
Ask doubts
