SPPU SE AI&DS syllabus

SPPU · Second Year Artificial Intelligence and Data Science · 2024 Pattern (Revised)

Database Management Systems

PCC-251-AID · Semester IV · 3 credits · CCE 40 + end-semester 60

All notes for this subject
  1. Unit 1: Data Management and the ER Model

    9 hours

    Purpose and applications of DBMS; data models, architecture and languages; entities, attributes, relationships, keys and constraints; ER diagrams and design issues; extended ER; converting ER and EER diagrams to tables.

    Marks: 12 in the end-semester exam · CCE: Unit test (15 marks, Units 1 & 2)

    • Purpose of a DBMS
    • DBMS architecture and data models
    • ER model and ER diagrams
    • Extended ER features
    • Converting ER diagrams to tables
  2. Unit 2: SQL and PL/SQL

    9 hours

    SQL data types and DDL, DML, DCL and TCL; users, grant and revoke; select, joins and views; aggregates, set operations and nested queries; PL/SQL procedures, functions, triggers, assertions and roles.

    Marks: 12 in the end-semester exam · CCE: Unit test (15 marks, Units 1 & 2)

    • DDL, DML, DCL and TCL
    • Joins and views
    • Aggregate functions and set operations
    • Nested queries
    • PL/SQL procedures and functions
    • Triggers
  3. Unit 3: Relational Model and Normalisation

    9 hours

    Attributes, domains and Codd's rules; domain, referential and enterprise constraints; functional dependencies, decomposition and normal forms up to BCNF; intelligent query processing.

    Marks: 12 in the end-semester exam · CCE: Assignments or case study (15 marks, Units 3 & 4)

  4. Unit 4: Transactions and Recovery

    9 hours

    Transaction states and ACID; schedules; conflict and view serialisability; recoverable schedules and cascading aborts; lock- and timestamp-based concurrency control; deadlocks; shadow paging, log-based recovery and checkpoints.

    Marks: 12 in the end-semester exam · CCE: Assignments or case study (15 marks, Units 3 & 4)

    • Transactions and ACID properties
    • Conflict and view serialisability
    • Recoverable schedules
    • Lock-based concurrency control
    • Timestamp-based concurrency control
    • Log-based recovery and checkpoints
  5. Unit 5: NoSQL and Emerging Databases

    9 hours

    Structured, semi-structured and unstructured data; key-value, document, graph and wide-column stores; BASE versus ACID; cloud, mobile, SQLite and XML databases; MongoDB CRUD, indexing, aggregation, replication and sharding; Neo4j; Cosmos DB.

    Marks: 12 in the end-semester exam · CCE: Seminar, open-book test or quiz (10 marks, Unit 5)

    • NoSQL database types
    • ACID versus BASE
    • MongoDB CRUD and aggregation
    • Replication and sharding
    • Graph databases with Neo4j

Unit contents are summarised from the official SPPU syllabus . AiCanCode.org is not affiliated with Savitribai Phule Pune University.