This course on Database Management System covers the following learning outcomes and goals: understanding the basics of DBMS, comparing file processing systems with DBMS, learning about keys in DBMS, exploring functional dependency and Armstrong's axioms, grasping the concept of normalization including 1NF, 2NF, 3NF, and BCNF, practicing identifying normal forms, studying dependency preserving and lossless join decomposition, and delving into canonical cover. The course teaches skills such as identifying keys, normalizing data, decomposing relations, and ensuring lossless join decomposition. The teaching method includes theoretical explanations, examples, practice questions, and problem-solving sessions. The intended audience for this course includes students, professionals, or anyone interested in understanding and mastering the concepts of Database Management Systems.
Overview
Syllabus
Introduction to DBMS | Database Management System.
File processing system in dbms | disadvantages of file system | file system vs DBMS.
Super Key | Candidate Key | Primary Key | Types of keys in DBMS.
Functional dependency in DBMS | What is functional dependency | Database Management System.
Armstrong's axioms in DBMS | Inference rules of Functional Dependency.
What is Attribute Closure | Closure set of Attribute in DBMS | How to find Closure of Attributes.
Part-1 Find Number of Candidate Keys in a relation | DBMS.
Part-2 Finding number of candidate keys in relation | DBMS.
Basic concept of normalization | Need of Normalization in DBMS.
First Normal Form in DBMS | 1NF with example | Normalization in dbms.
Second Normal Form in DBMS | 2NF in dbms | Normalization in DBMS.
Third Normal Form in DBMS | 3NF with example | Normalization in DBMS.
BCNF in DBMS | Boyce Codd Normal Form | Normalization in dbms.
Part 1 How to identify normal form in dbms | how to find highest normal form of a relation.
Part 2 Identify highest normal form of a relation practice questions | Normalization in dbms.
Dependency preserving decomposition in DBMS | with example.
Dependency Preserving Decomposition in DBMS | Practice questions.
Lossless Join Decomposition in DBMS | Non additive join decomposition property in dbms.
Practice questions on Lossless Join Decomposition | DBMS.
What is Canonical Cover in DBMS | Minimal cover Irreducible with example.
Practice problem on Lossless Join Decomposition in DBMS | check whether decomposition is lossless.
How to Decompose a Relation into 2NF (Second Normal Form) | DBMS.
How to Decompose a Relation into 3NF (Third Normal Form) with example | convert 2NF to 3NF | DBMS.
Taught by
Jenny's lectures CS/IT NET&JRF
