
विषय – सूची
- Introduction – What is DBMS
- DBMS vs. File System
- DBMS Architecture
- Three schema Architecture in DBMS
- Data model Schema and Instance
- Data Independence
- Database Language
- ER model concept
- Mapping Constraints
- DBMS Keys
- Generalization
- Specialization
- Aggregation
- Convert ER diagram to Table
- Relationship of higher degree
- Relational Algebra
- Join operation
- Integrity Constraints
- Relational Calculus
- Functional Dependency
- Normalization
- First Normal Form (1NF)
- Second Normal Form (2NF)
- Third Normal Form (3NF)
- BCNF
- Fourth normal form (4NF)
- Fifth normal form (5NF)
- Multivalued Dependency
- Join Dependency
- Transaction
- Schedule
- Conflict Serializability
- View Serializability
- Log Based Recovery
- Checkpoint
- Deadlock
- Concurrency Control
- Lock Based Protocol
- Timestamp protocol
- File organization
- Indexing
- B+ Tree
- Hashing
- RAID
- SQL
- Characteristics of SQL