Overview
Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Gain a comprehensive understanding of database normalization in this 58-minute video lecture. Explore the concept of functional dependency, Armstrong's axioms, and the necessity of normalization in database design. Learn about various anomalies caused by redundant data, including insertion, deletion, and update anomalies. Discover the different types of normal forms, from 1NF to BCNF, and understand their importance in creating efficient database structures. Enhance your knowledge of database management systems with practical examples and in-depth explanations, preparing you for placements and real-world applications.
Syllabus
- What is Functional Dependency?
- Armstrong's Axioms
- Why Normalisation is necessary?
- Anomalies due to redundant data
- Insertion Anomaly
- Deletion Anomaly
- Updation Anomaly
- What we actually do in Normalisation?
- Types of Normal Forms
- 1NF
- 2NF
- 3NF
- BCNF
Taught by
CodeHelp - by Babbar