Database Management Systems syllabus
2019 PATTERN. This is the 2019 pattern syllabus, the latest SPPU has published on its site for Third Year Computer Engineering. A 2024 pattern syllabus for this year has not been published there yet, so confirm with your college which pattern applies to you.
310241 · Third Year Computer Engineering, SPPU 2019 pattern. Every unit, the marks scheme, course outcomes and books, copied from the official syllabus PDF.
Unit-wise syllabus
Introduction to Database Management Systems and ER Model
6 hoursIntroduction, Purpose of Database Systems, Database-System Applications, View of Data, Database Languages, Database System Structure, 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 ER and EER diagram into tables.
SQL and PL/SQL
7 hoursSQL: Characteristics and Advantages, SQL Data Types and Literals, DDL, DML, DCL, TCL, SQL Operators. Tables: Creating, Modifying, Deleting, Updating.SQL DML Queries: SELECT Query and clauses, Index and Sequence in SQL. Views: Creating, Dropping, Updating using Indexes, Set Operations, Predicates and Joins, Set membership, Tuple Variables, Set comparison, Ordering of Tuples, Aggregate Functions, SQL Functions, Nested Queries.PL/SQL: Concept of Stored Procedures and Functions, Cursors, Triggers, Assertions, Roles and Privileges.
Relational Database Design
6 hoursRelational Model: Basic concepts, Attributes and Domains, CODD's Rules. Relational Integrity: Domain, Referential Integrities, Enterprise Constraints. Database Design: Features of Good Relational Designs, Normalization, Atomic Domains and First Normal Form, Decomposition using Functional Dependencies, Algorithms for Decomposition, 2NF, 3NF, BCNF.
Database Transaction Management
7 hoursIntroduction to Database Transaction, Transaction states, ACID properties, Concept of Schedule, Serial Schedule. Serializability: Conflict and View, Cascaded Aborts, Recoverable and Non-recoverable Schedules. Concurrency Control: Lock-based, Time-stamp based Deadlock handling. Recovery methods: Shadow-Paging and Log-Based Recovery, Checkpoints. Log-Based Recovery: Deferred Database Modifications and Immediate Database Modifications.
NoSQL Databases
7 hoursIntroduction to Distributed Database System, Advantages, Disadvantages, CAP Theorem. Types of Data: Structured, Unstructured Data and Semi-Structured Data. NoSQL Database: Introduction, Need, Features. Types of NoSQL Databases: Key-value store, document store, graph, wide column stores, BASE Properties, Data Consistency model, ACID Vs BASE, Comparative study of RDBMS and NoSQL. MongoDB (with syntax and usage): CRUD Operations, Indexing, Aggregation, MapReduce, Replication, Sharding.
Advances in Databases
7 hoursEmerging Databases: Active and Deductive Databases, Main Memory Databases, Semantic Databases. Complex Data Types: Semi-Structured Data, Features of Semi-Structured Data Models. Nested Data Types: JSON, XML. Object Orientation: Object-Relational Database System, Table Inheritance, Object- Relational Mapping. Spatial Data: Geographic Data, Geometric Data.
Marks and credits
| Head | Marks | Credit |
|---|---|---|
| Mid-Sem (mid-semester exam) | 30 | 3 |
| End-semester exam | 70 |
Prerequisite: Discrete Mathematics (210241), Data Structures and Algorithms (210252).
Course outcomes
- CO1Analyze and design Database Management System using ER model
- CO2Implement database queries using database languages
- CO3Normalize the database design using normal forms
- CO4Apply Transaction Management concepts in real-time situations
- CO5Use NoSQL databases for processing unstructured data
- CO6Differentiate between Complex Data Types and analyze the use of appropriate data types
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", Pearson Education, ISBN 81-7808-861-4
- Pramod J. Sadalage and Martin Fowler, “NoSQL Distilled”, Addison Wesley, ISBN- 10: 0321826620, ISBN-13: 978-0321826626
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
- Seema Acharya, “Demystifying NoSQL”, Wiley Publications, ISBN: 9788126579969
FAQ
How many units are in Database Management Systems?
Database Management Systems (310241) has 6 units: Unit I Introduction to Database Management Systems and ER Model (6 h); Unit II SQL and PL/SQL (7 h); Unit III Relational Database Design (6 h); Unit IV Database Transaction Management (7 h); Unit V NoSQL Databases (7 h); Unit VI Advances in Databases (7 h).
What is the marks scheme for Database Management Systems?
The official Computer Engineering 2019 pattern syllabus lists mid-semester (Mid-Sem) 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 (210241), Data Structures and Algorithms (210252).