DBMS (Database Management System)

Watch and track your favorite playlist.

Curated by: Jenny's Lectures CS IT (24 videos)

---

Tracks in this Playlist

• Lec 1: Introduction to DBMS | Database Management System
• Lec 2: File processing system in dbms | Disadvantages of file system | File System vs DBMS
• Lec 3: Super Key | Candidate Key | Primary Key | Types of keys in DBMS
• Lec 4: Functional dependency in DBMS | What is functional dependency | Database Management System
• Lec 5: Armstrong's axioms in DBMS | Inference rules of Functional Dependency
• Lec6:What is Attribute Closure |Closure set of Attribute in DBMS | How to find Closure of Attributes
• Lec 7: How to Find Number of Candidate Keys in a Relation - part 1 | DBMS Tutorials
• Lec 8: Finding number of candidate keys in relation - part 2 | DBMS
• Lec 9: Normalization in DBMS | Need of Normalization | DBMS Tutorials
• Lec 10: First Normal Form in DBMS | 1NF with example | Normalization in DBMS
• Lec 11: Second Normal Form in DBMS | 2NF in DBMS | Normalization in DBMS
• Lec 12: Third Normal Form in DBMS | 3NF with example | Normalization in DBMS
• Lec 13: BCNF in DBMS | Boyce Codd Normal Form | Normalization in DBMS
• Lec 14: How to find out Normal form of a Relation| how to identify Highest Normal Form | part1
• Lec15: Find Highest Normal Form of a Relation| Practice Problem - part2 | Normalization in DBMS
• Lec 16: Dependency preserving decomposition in DBMS | with example | DBMS Tutorials for beginners
• Lec 17: Dependency Preserving Decomposition in DBMS | Practice Problem
• Lec 18: Lossless Join Decomposition | Non Additive Join Decomposition Property | DBMS Tutorials
• Lec 19: Practice Problem on Lossless Join Decomposition | DBMS Tutorials
• Lec 21: What is Canonical Cover in DBMS | Minimal cover Irreducible with example
• Lec 20: Problem on Lossless Join Decomposition in DBMS | Check whether Decomposition is Lossless
• Lec 22: How to Decompose a Relation into 2NF (Second Normal Form) | DBMS
• Lec23: How to Decompose a Relation into 3NF(Third Normal Form) with example | Convert 2NF to 3NF
• Lec 24: How to Normalize a Relation Table in DBMS | with example