SPPU · Second Year Information Technology · 2024 Pattern (Revised)
Database Management System
PCC-251-ITT · Semester IV · 3 credits · CCE 40 + end-semester 60
Unit 1: Introduction to DBMS
8 hoursDBMS 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
Unit 2: Relational Model and Database Design
8 hoursDomains, 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
Unit 3: SQL and PL/SQL
8 hoursSQL 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
Unit 4: Transactions and Concurrency Control
8 hoursTransactions, 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
Unit 5: Emerging Database Technologies
6 hoursWhy 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.