Lesson 2 of 42 β’ 1 upvotes β’ 6:52mins
Introduction to Normalization - what is Normalization and why it is required
42 lessons β’ 4h 28m
Normalization - Course Overview
2:01mins
Introduction to Normalization
6:52mins
Introduction to FDs
6:43mins
FD Examples and GATE 2000 Question
8:53mins
GATE 2002 question on FDs
3:31mins
Inference rules
5:06mins
Closure set of attributes
5:39mins
GATE 2006 Question on Closure Set of Attributes
4:14mins
Candidate Keys
7:03mins
Determining Candidate keys
6:51mins
GATE 96 question on Candidate keys
7:54mins
GATE 2014 question on Candidate key
3:40mins
GATE 2005 question on CK
9:25mins
GATE 2013 question on CK
8:21mins
Example on Candidate key
10:43mins
Determining CK of subrelation
4:33mins
GATE IT 05 question on Additional FDs
3:59mins
Equivalence of FDs
6:54mins
Example on Equivalence of FDs
5:06mins
Minimal Cover
7:02mins
Example on Minimal Cover
7:00mins
GATE 2013 question on Minimal Cover
6:58mins
Lossy vs Lossless Decomposition
8:44mins
Dependency preservation
7:26mins
Dependency preservation Example 1
6:16mins
Dependency preservation Example 2
7:17mins
Dependency preservation Example 3
2:53mins
First Normal Form
3:19mins
Second Normal Form
5:54mins
2NF Example
5:05mins
Third Normal Form
4:20mins
3NF Example 1
6:09mins
3NF Example 2
3:52mins
3NF Example 3
7:20mins
BCNF INTRODUCTION
2:55mins
BCNF Eg 1 - GATE 95 question on Normalization
5:14mins
BCNF Example 2
10:14mins
BCNF Example 3
6:02mins
BCNF Example 4
7:20mins
BCNF Example 5
7:24mins
GATE Questions on Normalization - 1
9:57mins
GATE Questions on Normalization - 2
12:03mins