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
Unit 1: Data Management and the ER Model
9 hoursPurpose 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
Unit 2: SQL and PL/SQL
9 hoursSQL 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
Unit 3: Relational Model and Normalisation
9 hoursAttributes, 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)
- Relational model and Codd's rules
- Integrity constraints
- Functional dependencies
- Normalisation: 1NF to BCNF
- Intelligent query processing
Unit 4: Transactions and Recovery
9 hoursTransaction 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
Unit 5: NoSQL and Emerging Databases
9 hoursStructured, 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.