SPPU · Second Year Computer Engineering · 2024 Pattern (Revised)
Database Management Systems
PCC-251-COM · Semester IV · 3 credits · CCE 40 + end-semester 60
Unit 1: Introduction to Database Management System
9 hoursPurpose 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)
Unit 2: SQL and PL/SQL
9 hoursDDL, 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)
Unit 3: Relational Database Design
9 hoursThe 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)
Unit 4: Database Transactions
9 hoursTransactions 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)
Unit 5: NoSQL Database
9 hoursNoSQL 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.