Please Login To Continue

Determining CK of subrelation

Lesson 16 of 42 β€’ 0 upvotes β€’ 4:33mins

Avatar

Nisha Sajnani

Determining CK of subrelation which will be used for finding CKs of the decomposed table

Continue on app
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
Structured syllabus
Daily live classes
Daily live classes
Ask doubts
Ask doubts
Tests & practice
Tests & practice

Similar Plus Courses

thumbnail
ENROLL
HinglishDisaster Management

Complete Course on Disaster Management - UPSC CSE - GS

Sumit Konde

Unacademy is India’s largest online learning platform. Download our apps to start learning


Starting your preparation?

Call us and we will answer all your questions about learning on Unacademy

Call +91 8585858585
Company
About usShikshodayaCareersBlogsPrivacy PolicyTerms and Conditions
Products
Learner appLearner appEducator appEducator appParent appParent app