SPPU SE IT syllabus

SPPU · Second Year Information Technology · 2024 Pattern (Revised)

Database Management System

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

All notes for this subject
  1. Unit 1: Introduction to DBMS

    8 hours

    DBMS versus file systems, data abstraction and independence, database languages, DBMS structure and multi-user architecture; entities, attributes, relationships, constraints, keys and data models; ER and EER diagrams and converting them to tables.

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

    • DBMS versus file processing systems
    • Data abstraction and data independence
    • DBMS architecture and database languages
    • Keys and constraints
    • ER model and ER diagrams
    • EER model and mapping to tables
  2. Unit 2: Relational Model and Database Design

    8 hours

    Domains, attributes, tuples and relations, relational constraints and schemas, Codd's rules; good design, redundancy and anomalies; functional dependencies; 1NF, 2NF, 3NF and BCNF.

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

    • Relational model concepts and constraints
    • Codd's rules
    • Data redundancy and anomalies
    • Functional dependencies
    • Normal forms: 1NF, 2NF and 3NF
    • Boyce–Codd normal form
  3. Unit 3: SQL and PL/SQL

    8 hours

    SQL data types, DDL, constraints and DML; SELECT with WHERE, ORDER BY, LIKE, IN, BETWEEN, GROUP BY and HAVING; joins, subqueries, set operations, views and indexes; PL/SQL control structures, cursors, procedures, functions and triggers.

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

    • SQL DDL and constraints
    • SQL DML and SELECT queries
    • Aggregate functions, GROUP BY and HAVING
    • Joins
    • Subqueries and set operations
    • Views and indexes
    • PL/SQL blocks and cursors
    • Stored procedures, functions and triggers
  4. Unit 4: Transactions and Concurrency Control

    8 hours

    Transactions, states and ACID; serial and concurrent schedules, conflict and view serializability, cascadeless and recoverable schedules; lock-based, timestamp and validation protocols, multiple granularity and deadlock; 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
    • Schedules and serializability
    • Recoverable and cascadeless schedules
    • Lock-based protocols and two-phase locking
    • Timestamp and validation protocols
    • Deadlocks in databases
    • Recovery: logs, checkpoints and shadow paging
  5. Unit 5: Emerging Database Technologies

    6 hours

    Why traditional databases struggle with scale; NoSQL document, key-value, column and graph stores with MongoDB; cloud databases and DBaaS; big data, Hadoop and HDFS; machine learning inside databases.

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

    • NoSQL databases and their types
    • MongoDB basics
    • Cloud databases and DBaaS
    • Big data, Hadoop and HDFS

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