Database Management System (BCS501) AKTU syllabus – unit-wise topics
The complete Database Management System syllabus for AKTU, unit by unit. Next to each topic you can see how often it has appeared in past papers, so you know where the marks are.
Unit 1: Introduction and ER Model
- Database System Overview – asked 8 times
- Data Model Schema Instances – asked 9 times
- Entity Relationship Model – asked 8 times
Unit 2: Relational Model and SQL
- Relational Data Model – asked 9 times
- SQL Basics and Commands – asked 4 times
- SQL Queries and Operations – asked 9 times
- Cursors Triggers Procedures – asked 4 times
Unit 3: Database Design and Normalization
- Functional Dependencies – asked 9 times
- Normal Forms – asked 7 times
- Lossless Join Decomposition – asked 3 times
- Normalization Using FD MVD JD – asked 4 times
Unit 4: Transaction Processing and Distributed DB
- Transaction Processing Concepts – asked 21 times
- Log Based Recovery Checkpoints – asked 2 times
- Deadlock Handling – asked 3 times
- Distributed Database
Unit 5: Concurrency Control Techniques
- Locking Techniques Concurrency – asked 5 times
- Timestamp Protocols Concurrency – asked 5 times
- Validation Based Protocol – asked 3 times
- Multiple Granularity Multi Version – asked 2 times
- Recovery with Concurrent Transactions – asked 3 times
- Oracle Case Study