GATE Questions on Normalization - 1

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