Database Management Systems syllabus
PCC-251-CSE · Second Year Computer Science and Engineering, SPPU 2024 pattern. Every unit, the marks scheme, course outcomes and books, copied from the official syllabus PDF.
Unit-wise syllabus
Introduction to Database Management System
9 hoursIntroduction to Database Management Systems, Purpose of Database Systems, Database-System Applications, View of Data, Database Languages, Database System Structure, Enterprise Constraints Data Models, Database Design and ER Model: Entity, Attributes, Relationships, Constraints, Keys, Design Process, Entity Relationship Model, ER Diagram, Design Issues, Extended E-R Features, Converting E-R & EER diagram into tables.
Case Study: Study of Architecture of any DBMS like Oracle or MySQL. Design a database schema for any problem given in previous Question Papers.
SQL and PL/SQL
9 hoursSQL: DDL, DML, Select Queries, String, Date and Numerical Functions, Aggregate Functions ,View, Indexes, Group by and Having Clause, Join Queries, Set, Set operation, Set membership, Nested queries, DCL, TCL PL/SQL: Control Statement, Cursor, Stored Procedure and Function, Trigger
Case Study : Design and implement a Student Course Management System using SQL and PL/SQL to manage students, courses, and faculty members efficiently. The system should store and retrieve relevant data, ensuring integrity, security, and performance optimization.
Relational Database Design
9 hoursRelational Model: Basic concepts, Attributes and Domains, CODD’s Rules, Relational Integrity, Referential Integrities, Database Design: Features of Good Relational Designs, Normalization, Atomic Domains and First Normal Form, Decomposition using Functional Dependencies, 2NF, 3NF, BCNF.
Case study: Design and Optimization of a Relational Database for a University Management System
Database Transactions
9 hoursBasic concept of a Transaction, Transaction Management, Properties of Transactions, ACID, Concept of Schedule, Serial Schedule, Serializability: Conflict and View, Cascaded Aborts, Recoverable and Non-recoverable Schedules, Concurrency Control: Need, Locking Methods.
Case study : Design Online Shopping Cart Transaction Management In an e-commerce platform, multiple users simultaneously add, update, and purchase products. To ensure data consistency and reliability, the system must handle concurrent transactions effectively.
NoSQL Database
9 hoursIntroduction to NoSQL Database, NoSQL data models, CAP theorem and BASE Properties, Comparative study of SQL and NoSQL, MongoDB: CRUD Operations, Indexing and Aggregation.
Case study: Study NoSQL Database Selection for a Social Media Platform.
Marks and credits
| Head | Marks | Credit |
|---|---|---|
| CCE (continuous comprehensive evaluation) | 40 | 3 |
| End-semester exam | 60 |
Prerequisite: Discrete Mathematics, Data Structures and Algorithms.
Course outcomes
- CO1Explain the fundamentals of database management systems, including data models, ER modeling, and database design.
- CO2Develop and execute SQL and PL/SQL programs to manage and manipulate relational data.
- CO3Apply normalization techniques to improve database design and ensure data integrity.
- CO4Analyze transaction management concepts and concurrency control techniques for reliable database systems
- CO5Evaluate NoSQL database types and explain their suitability 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
- D T Editorial Services "BIG DATA Black Book", Dreamtech Press ISBN 13 : 9789351199311
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
- 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-CSE) has 5 units and 45 hours of theory: Unit I Introduction to Database Management System (9 h); Unit II SQL and PL/SQL (9 h); Unit III Relational Database Design (9 h); Unit IV Database Transactions (9 h); Unit V NoSQL Database (9 h).
What is the marks scheme for Database Management Systems?
The official Computer Science and Engineering 2024 pattern syllabus lists continuous comprehensive evaluation (CCE) for 40 marks and the end-semester exam for 60 marks, for 3 credits.
What should I know before Database Management Systems?
Prerequisite listed in the syllabus: Discrete Mathematics, Data Structures and Algorithms.