Please Login To Continue
Determining Candidate keys
Lesson 10 of 42 тАв 0 upvotes тАв 6:51mins
Nisha Sajnani
How to determine Candidate key and number of candidate keys possible on a relation
Understanding Normalization with Previous Year GATE Questions - GATE(CS and IT)
42 lessons тАв 4h 28m
1
Normalization - Course Overview
2:01mins
2
Introduction to Normalization
6:52mins
3
Introduction to FDs
6:43mins
4
FD Examples and GATE 2000 Question
8:53mins
5
GATE 2002 question on FDs
3:31mins
6
Inference rules
5:06mins
7
Closure set of attributes
5:39mins
8
GATE 2006 Question on Closure Set of Attributes
4:14mins
9
Candidate Keys
7:03mins
10
Determining Candidate keys
6:51mins
11
GATE 96 question on Candidate keys
7:54mins
12
GATE 2014 question on Candidate key
3:40mins
13
GATE 2005 question on CK
9:25mins
14
GATE 2013 question on CK
8:21mins
15
Example on Candidate key
10:43mins
16
Determining CK of subrelation
4:33mins
17
GATE IT 05 question on Additional FDs
3:59mins
18
Equivalence of FDs
6:54mins
19
Example on Equivalence of FDs
5:06mins
20
Minimal Cover
7:02mins
21
Example on Minimal Cover
7:00mins
22
GATE 2013 question on Minimal Cover
6:58mins
23
Lossy vs Lossless Decomposition
8:44mins
24
Dependency preservation
7:26mins
25
Dependency preservation Example 1
6:16mins
26
Dependency preservation Example 2
7:17mins
27
Dependency preservation Example 3
2:53mins
28
First Normal Form
3:19mins
29
Second Normal Form
5:54mins
30
2NF Example
5:05mins
31
Third Normal Form
4:20mins
32
3NF Example 1
6:09mins
33
3NF Example 2
3:52mins
34
3NF Example 3
7:20mins
35
BCNF INTRODUCTION
2:55mins
36
BCNF Eg 1 - GATE 95 question on Normalization
5:14mins
37
BCNF Example 2
10:14mins
38
BCNF Example 3
6:02mins
39
BCNF Example 4
7:20mins
40
BCNF Example 5
7:24mins
41
GATE Questions on Normalization - 1
9:57mins
42
GATE Questions on Normalization - 2
12:03mins
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
