Here are the notes for Database Management System (DBMS). Just click on any topic to download its notes in doc format.
Unit 1
- DBMS Introduction
- File System
- Hierarchical Data Model
- Network Data Model
- Relational Data Model
- Object-Oriented Data Model
- History of DBMS
- File System vs DBMS
- What is Database
- Data Abstraction
- Instance and Schema
- Data Independence
- Keys in DBMS
- ER Model & Types of Attributes
- How to Draw ER Diagram
- Convert ER Diagram to Table
- Types of Database Systems
- Centralized Database System
- Distributed Database System
- Parallel Database System
- Client-Server Database System
- Database Languages
- DBMS Interfaces
- Database Users
- Overall Structure of DBMS
- 4th Generation Language
- What is Metadata
- Mapping and Participation Constraints
- Existence Dependency
- Generalization, Specialization and More
- Degree of Relationship
- Cardinality Ratio
- Integrity Constraints
Unit 2
- Data Types
- SQL Notes Video 37 to 45
- SQL Notes Video 46 to 54
- SQL Notes Video 55 to 63
- Relational Algebra
- Triggers
- Anomalies in DBMS
- Decomposition
- Functional Dependency
- Normalization – 1NF, 2NF, 3NF, BCNF, 4NF, 5NF
- Conclusion of Normalization
- 6NF, DKNF, ETNF, EKNF
- Prime and Non-Prime Attributes, Armstrong’s Axioms
- Closure of a Set of Functional Dependencies
- Canonical Cover and Minimal Cover
- Transaction in DBMS
- ACID Properties
- Transaction States
- Serial and Parallel Execution of Transaction
- Concurrent Execution of Transaction
- Transaction Schedules
- Serializability in DBMS
- Deadlock in Database
More notes coming soon!