Mumbai University SE IT syllabus

Mumbai University · Second Year Information Technology · NEP 2020

Database Management System & Application

2343113 · Semester III · 3 credits · Internal tests 40 + end-semester 60

End-semester paper (2 hours): Six questions of 15 marks; Q1 is compulsory and you answer four.

All notes for this subject
  1. Module 1: Database System Concepts and Applications

    5 hours

    Characteristics of databases; file systems versus databases; data abstraction and independence; DBMS architecture; the DBA and their role; applications in banking, e-commerce, healthcare and more.

    Examined in one of the two internal tests and in the 60-mark end-semester paper

    • DBMS versus file processing systems
    • Data abstraction and data independence
    • DBMS architecture and database languages
    • Role of the database administrator
  2. Module 2: The Entity–Relationship Model

    5 hours

    Conceptual modelling; entities, attributes, keys and relationships; weak entities; generalisation, specialisation and aggregation; the EER model.

    Examined in one of the two internal tests and in the 60-mark end-semester paper

    • ER model and ER diagrams
    • EER model and mapping to tables
  3. Module 3: Relational Model and Relational Algebra

    5 hours

    Relational constraints and schemas; primary, secondary and foreign keys; mapping ER and EER models to relations; unary, set and binary relational algebra operations and queries.

    Examined in one of the two internal tests and in the 60-mark end-semester paper

    • Relational model concepts and constraints
    • Keys and constraints
    • Relational algebra
  4. Module 4: SQL and Indexing

    8 hours

    DDL, DML and DCL; set operations, aggregates and nulls; GROUP BY; recursive and nested queries; integrity constraints; JDBC; GRANT and REVOKE; functions, procedures and cursors; ordered indices.

    Examined in one of the two internal tests and in the 60-mark end-semester paper

    • SQL DDL and constraints
    • SQL DML and SELECT queries
    • Aggregate functions, GROUP BY and HAVING
    • Subqueries and set operations
    • Recursive queries
    • Database programming with JDBC
    • GRANT and REVOKE
    • Stored procedures, functions and triggers
    • PL/SQL blocks and cursors
    • Views and indexes
  5. Module 5: Relational Database Design

    7 hours

    Design guidelines; functional dependencies; the need for and process of normalisation; 1NF, 2NF, 3NF and BCNF.

    Examined in one of the two internal tests and in the 60-mark end-semester paper

    • Data redundancy and anomalies
    • Functional dependencies
    • Normal forms: 1NF, 2NF and 3NF
    • Boyce–Codd normal form
  6. Module 6: Transactions, Concurrency and Recovery

    7 hours

    Transaction states and ACID; concurrent executions; conflict and view serialisability; lock-based and timestamp protocols; deadlock handling; log-based recovery.

    Examined in one of the two internal tests and in the 60-mark end-semester paper

    • Transactions and ACID properties
    • Schedules and serializability
    • Lock-based protocols and two-phase locking
    • Timestamp and validation protocols
    • Deadlocks in databases
    • Recovery: logs, checkpoints and shadow paging

Module contents are summarised from the official Mumbai University syllabus . AiCanCode.org is not affiliated with the University of Mumbai.