Database Management Systems syllabus
PCC-251-CYB · Second Year Cyber Security, 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.
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
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.
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.
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.
Marks and credits
| Head | Marks | Credit |
|---|---|---|
| CCE (continuous comprehensive evaluation) | 40 | 3 |
| End-semester exam | 60 |
Prerequisite: 1. Data Structures and Algorithms 2. Discrete Mathematics.
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-CYB) 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 Cyber Security 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: 1. Data Structures and Algorithms 2. Discrete Mathematics.