RTMNU · Third Year B.Tech Artificial Intelligence & Data Science · NEP 2020
Database Management System
BAD5T16 · Semester V · 3 credits · College 30 + university 70
Unit 1: Database Fundamentals & Data Modeling
7 hoursDatabase concepts, purpose, data abstraction and independence, users and the DBA, DBMS and three-schema architecture, data models; the ER model with keys, relationships, weak entities, extended ER features and ER-to-relational mapping.
Examined in the 70-mark end-semester paper
- Purpose of a DBMS
- DBMS architecture and data models
- Three-schema architecture, schemas and instances
- ER model and ER diagrams
- Extended ER features
- Converting ER diagrams to tables
Unit 2: Relational Model & Relational Algebra
7 hoursRelational model concepts, schemas and instances, keys, integrity and referential constraints, relational algebra operators, views and logical design.
Examined in the 70-mark end-semester paper
- Relational model and Codd's rules
- Integrity constraints
- Relational algebra
- Joins and views
Unit 3: SQL and Advanced SQL
7 hoursDDL, DML and DCL, data types and constraints, basic and complex queries, aggregates with GROUP BY and HAVING, joins, nested subqueries, set operations, views, transaction control, stored procedures and triggers.
Examined in the 70-mark end-semester paper
- DDL, DML, DCL and TCL
- Aggregate functions and set operations
- Nested queries
- PL/SQL procedures and functions
- Triggers
Unit 4: Database Design & Transaction Management
7 hoursFunctional dependencies and their closure, normal forms 1NF to BCNF, decomposition and dependency preservation; transactions, ACID properties, states, concurrency anomalies and serialisability.
Examined in the 70-mark end-semester paper
- Functional dependencies
- Normalisation: 1NF to BCNF
- Lossless join and dependency preservation
- Transactions and ACID properties
- Conflict and view serialisability
Unit 5: Storage, Indexing & Modern Databases
7 hoursFile organisation, primary and secondary indexing, B+ trees and hashing; lock-based concurrency control, deadlock handling, recovery with logging and checkpoints; NoSQL database types compared with SQL.
Examined in the 70-mark end-semester paper
- Indexing: ordered, B+-tree and hash indices
- Lock-based concurrency control
- Deadlock handling in databases
- Log-based recovery and checkpoints
- NoSQL database types
- ACID versus BASE
Unit contents are summarised from the official RTMNU syllabus . AiCanCode.org is not affiliated with Rashtrasant Tukadoji Maharaj Nagpur University (RTMNU).