Database Management Systems syllabus
PCC-251-AID · Second Year Artificial Intelligence and Data Science, SPPU 2024 pattern. Every unit, the marks scheme, course outcomes and books, copied from the official syllabus PDF.
Unit-wise syllabus
Foundations of Data Management and ER Model
9 hoursIntroduction, Purpose of DBMS, Database Applications, Data Models, DBMS Architecture, DBMS languages. Database Design and ER Model: Entities, Attributes, Relationships, Keys, Constraints, ER Diagrams, Design Process, Design Issues. Extended ER features, converting ER/EER diagrams to relational tables
Case Study: Analyze and design a database using the ER model for a real-time application and convert it to relational tables.
Smart Data Querying with SQL & PL/SQL
9 hoursSQL: Data types, DDL, DML, DCL, and TCL commands (Create User, Grant, Revoke Queries) Tables: Create, Insert, Update, Delete, Alter, Drop, SELECT, Joins, Views (Create, Update, Drop), Aggregation functions, Set operations, SQL Operators, SQL Predicates, Nested queries.PL/SQL: Stored procedures, functions, triggers, assertions, roles, and privileges.
Case Study : Implementation of Unit I case study using SQL and PL/SQL
Relational DBMS and Intelligent Querry Processing
9 hoursRelational model concepts: Attributes, Domains, CODD’s Rules. Integrity constraints: Domain, Referential integrity, Enterprise constraints. Normalization: 1NF to BCNF, functional dependencies, decomposition. Introduction to Intelligent Query Processing (IQP): Definition and importance of IQP, Evolution of query processing techniques, Need for intelligent query optimization in modern databases.
Case study: Normalize the relational database designed in Unit I
Transaction Management & Analytics
9 hoursTransactions: States, ACID properties, schedules. Serializability: Conflict and view serializability, cascaded aborts, recoverable and nonrecoverable schedules. Concurrency control: Lock-based and time-stamp-based mechanisms, deadlock handling. Recovery: Shadow-paging, log-based recovery, checkpoints, deferred and immediate modifications.
Case study : Study transaction management in PostgreSQL
NoSQL & Intelligent Data Processing
9 hoursData types: Structured, unstructured, and semi-structured data. NoSQL databases: Types (Keyvalue, Document, Graph, Wide-column), BASE properties, ACID vs. BASE, RDBMS vs. NoSQL Introduction to emerging database technologies : Cloud Databases, Mobile Databases, SQLite Database, XML Databases, DynamoDB. MongoDB: CRUD operations, indexing, aggregation, MapReduce, replication, sharding. Graph DB: Introduction, Building Rich Graph Data Models with Neo4j, Querying Your Graph Cosmos DB: Introduction, Building Scalable NoSQL Data Models, Querying with SQL API
Case study: Process unstructured social media data using NoSQL databases
Marks and credits
| Head | Marks | Credit |
|---|---|---|
| CCE (continuous comprehensive evaluation) | 30 | 3 |
| End-semester exam | 70 |
Prerequisite: Discrete Mathematics, Data Structures and Algorithms.
Course outcomes
- CO1Design Database Management Systems using ER models.
- CO2Execute database queries using SQL and PL/SQL.
- CO3Normalize database designs using normal forms.
- CO4Apply transaction management concepts to real-time scenarios.
- CO5Use NoSQL databases for handling unstructured data.
Books
Text books
- Silberschatz A., Korth H., Sudarshan S., "Database System Concepts", McGraw Hill Publishers, ISBN 0-07-120413-X, 6th edition
- Connally T., Begg C., "Database Systems", 4th Edition, Pearson Education, 2002, ISBN 8178088614
- “MongoDB: The Definitive Guide” by Kristina Chodorow, O Reilly Publications
- Pramod J. Sadalage Martin Fowler,” NoSQLDistilled”,Addison Wesley, ISBN- 10:0321826620
Reference books
- C J Date, “An Introduction to Database Systems”, Addison-Wesley, ISBN: 0201144719
- S.K.Singh, “Database Systems: Concepts, Design and Application”, Pearson Education, ISBN 978-81-317-6092-5 49
- Kristina Chodorow, Michael Dierolf, “MongoDB: The Definitive Guide”, O Reilly Publications, ISBN: 978-1-449-34468-9
- Adam Fowler, “NoSQL For Dummies”, John Wiley & Sons, ISBN-1118905628
- Kevin Roebuck, “Storing and Managing Big Data - NoSQL, HADOOP and More”, Emereopty Limited, ISBN: 1743045743, 9781743045749
- Joy A. Kreibich, “Using SQLite”, O’REILLY, ISBN: 13:978-93-5110-934-1
- Ivan Bayross, “SQL, PL/SQL the Programming Language of Oracle”, BPB Publications ISBN: 9788176569644, 9788176569644
NPTEL and SWAYAM links
Listed in the official syllabus:
FAQ
How many units are in Database Management Systems?
Database Management Systems (PCC-251-AID) has 5 units and 45 hours of theory: Unit I Foundations of Data Management and ER Model (9 h); Unit II Smart Data Querying with SQL & PL/SQL (9 h); Unit III Relational DBMS and Intelligent Querry Processing (9 h); Unit IV Transaction Management & Analytics (9 h); Unit V NoSQL & Intelligent Data Processing (9 h).
What is the marks scheme for Database Management Systems?
The official Artificial Intelligence and Data Science 2024 pattern syllabus lists continuous comprehensive evaluation (CCE) for 30 marks and the end-semester exam for 70 marks, for 3 credits.
What should I know before Database Management Systems?
Prerequisite listed in the syllabus: Discrete Mathematics, Data Structures and Algorithms.