SPPU SE Computer syllabus

SPPU · Second Year Computer Engineering · 2024 Pattern (Revised)

Database Management Systems

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

  1. Unit 1: Introduction to Database Management System

    9 hours

    Purpose and applications of database systems, views of data, languages and structure; data models; ER model, keys, extended ER features, mapping ER and EER diagrams to tables.

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

  2. Unit 2: SQL and PL/SQL

    9 hours

    DDL, DML, select queries, string, date, numeric and aggregate functions, views, indexes, GROUP BY and HAVING, joins, set operations, nested queries, DCL and TCL; PL/SQL control statements, cursors, procedures, functions and triggers.

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

  3. Unit 3: Relational Database Design

    9 hours

    The relational model, Codd's rules, relational and referential integrity; good designs, functional dependencies, decomposition, 1NF, 2NF, 3NF and BCNF.

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

  4. Unit 4: Database Transactions

    9 hours

    Transactions and ACID, schedules, conflict and view serialisability, cascading aborts, recoverable schedules, concurrency control and locking.

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

  5. Unit 5: NoSQL Database

    9 hours

    NoSQL data models, CAP theorem and BASE, SQL versus NoSQL; MongoDB CRUD, indexing and aggregation.

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

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