Never stop talking " STOP the Gaza Genocide "
  • Lesson.No : 23
  • 00:16:35

  • Lec23: How to Decompose a Relation into 3NF(Third Normal Form) with example Convert 2NF to 3NF

  • Play

Course Lessons

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