Completed
How to Decompose a Relation into 2NF (Second Normal Form) | DBMS
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
DBMS - Database Management System
Automatically move to the next video in the Classroom when playback concludes
- 1 Introduction to DBMS | Database Management System
- 2 File processing system in dbms | disadvantages of file system | file system vs DBMS
- 3 Super Key | Candidate Key | Primary Key | Types of keys in DBMS
- 4 Functional dependency in DBMS | What is functional dependency | Database Management System
- 5 Armstrong's axioms in DBMS | Inference rules of Functional Dependency
- 6 What is Attribute Closure | Closure set of Attribute in DBMS | How to find Closure of Attributes
- 7 Part-1 Find Number of Candidate Keys in a relation | DBMS
- 8 Part-2 Finding number of candidate keys in relation | DBMS
- 9 Basic concept of normalization | Need of Normalization in DBMS
- 10 First Normal Form in DBMS | 1NF with example | Normalization in dbms
- 11 Second Normal Form in DBMS | 2NF in dbms | Normalization in DBMS
- 12 Third Normal Form in DBMS | 3NF with example | Normalization in DBMS
- 13 BCNF in DBMS | Boyce Codd Normal Form | Normalization in dbms
- 14 Part 1 How to identify normal form in dbms | how to find highest normal form of a relation
- 15 Part 2 Identify highest normal form of a relation practice questions | Normalization in dbms
- 16 Dependency preserving decomposition in DBMS | with example
- 17 Dependency Preserving Decomposition in DBMS | Practice questions
- 18 Lossless Join Decomposition in DBMS | Non additive join decomposition property in dbms
- 19 Practice questions on Lossless Join Decomposition | DBMS
- 20 What is Canonical Cover in DBMS | Minimal cover Irreducible with example
- 21 Practice problem on Lossless Join Decomposition in DBMS | check whether decomposition is lossless
- 22 How to Decompose a Relation into 2NF (Second Normal Form) | DBMS
- 23 How to Decompose a Relation into 3NF (Third Normal Form) with example | convert 2NF to 3NF | DBMS
