RTMNU · Third Year B.Tech Electronics & Telecommunication Engineering · NEP 2020
Database Management
BMD5T19 · Semester V · 3 credits · College 30 + university 70
Unit 1: Introduction to Database Systems
7 hoursWhat a database system is and how a DBMS differs from a database, approaches to building one, data models, the three-schema architecture, the challenges of building a DBMS and its components.
Examined in the 70-mark end-semester paper
- DBMS versus file processing systems
- Data abstraction and data independence
- DBMS architecture and database languages
Unit 2: Relational Data Model
Relations and the schema–instance distinction, keys, referential integrity and foreign keys, relational algebra, tuple and domain relational calculus, SQL and PL/SQL.
Examined in the 70-mark end-semester paper
- Relational model concepts and constraints
- Keys and constraints
- Relational algebra
- Relational calculus
- SQL DDL and constraints
- SQL DML and SELECT queries
- PL/SQL blocks and cursors
Unit 3: Query Processing and Optimization
7 hoursThe query processing and optimisation process, estimating query cost, pipelining and materialisation, and the structure of query evaluation plans.
Examined in the 70-mark end-semester paper
- Query processing: selection, sorting and joins
- Query optimisation and evaluation plans
Unit 4: Transactions
8 hoursTransaction concepts and properties, serialisability and testing it, concurrent execution, locking and the two-phase commit protocol, deadlock and isolation, recovery and atomicity with log-based recovery.
Examined in the 70-mark end-semester paper
- Transactions and ACID properties
- Schedules and serializability
- Recoverable and cascadeless schedules
- Lock-based protocols and two-phase locking
- Deadlocks in databases
Unit 5: Recovery System and Advanced Databases
7 hoursFailure classification, log-based recovery, checkpoints, buffer management and advanced recovery; web and distributed databases, data warehousing and mining, data security and NoSQL databases.
Examined in the 70-mark end-semester paper
- Recovery: logs, checkpoints and shadow paging
- Distributed databases
- Data warehousing and data mining
- Database security: authentication, authorisation and encryption
- NoSQL databases and their types
Unit contents are summarised from the official RTMNU syllabus . AiCanCode.org is not affiliated with Rashtrasant Tukadoji Maharaj Nagpur University (RTMNU).