RTMNU TY E&TC syllabus

RTMNU · Third Year B.Tech Electronics & Telecommunication Engineering · NEP 2020

Database Management

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

All notes for this subject
  1. Unit 1: Introduction to Database Systems

    7 hours

    What 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
  2. 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
  3. Unit 3: Query Processing and Optimization

    7 hours

    The 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
  4. Unit 4: Transactions

    8 hours

    Transaction 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
  5. Unit 5: Recovery System and Advanced Databases

    7 hours

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