RTMNU TY AI & DS syllabus

RTMNU · Third Year B.Tech Artificial Intelligence & Data Science · NEP 2020

Database Management System

BAD5T16 · Semester V · 3 credits · College 30 + university 70

All notes for this subject
  1. Unit 1: Database Fundamentals & Data Modeling

    7 hours

    Database 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
  2. Unit 2: Relational Model & Relational Algebra

    7 hours

    Relational 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

  3. Unit 3: SQL and Advanced SQL

    7 hours

    DDL, 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
  4. Unit 4: Database Design & Transaction Management

    7 hours

    Functional 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

  5. Unit 5: Storage, Indexing & Modern Databases

    7 hours

    File 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).