Syllabus Database Management System & Application - (2343113) Theory Term work Pract / Oral Total Internal Assessment End Sem Exam Exam Duration (in Hrs) IAT - I IAT - II IAT - I + IAT - II 20 20 40 60 02 - - - - 100 Sr. No. Name of Module Detailed Content 0. Prerequisite C, Python Programming. I. Database System Concepts, Architecture, and Applications Introduction, Characteristics of Databases, File system v/s Database system, Data abstraction and Data Independence, DBMS system architecture, Database Administrator (DBA), Role of DBA. Applications : Banking Systems, E-Commerce, Telecommunications, Healthcare Systems, Social Media Platforms, Education Systems, Airline Reservation Systems, Government Applications. (Chapter - 1) Self-learning Topics : Identify the types of Databases. II. The Entity- Relationship Model Conceptual Modeling of a database, The Entity-Relationship (ER) Model, Entity Type, Entity Sets, Attributes and Keys, Relationship Types, Relationship Sets, Weak entity Types. Generalization, Specialization and Aggregation, Extended Entity-Relationship (EER) Model. (Chapter - 2) Self-learning Topics : Design an ER model for any real-time case study. III. Relational Model & Relational Algebra Introduction to Relational Model, Relational Model Constraints and Relational Database Schemas, Concept of Keys : Primary Key, Secondary key, Foreign Key, Mapping the ER and EER Model to the Relational Model, Introduction to Relational Algebra, Relational Algebra expressions for Unary Relational Operations, • Set Theory operations, • Binary Relational operation • Relational Algebra Queries. (Chapter - 3) Self-learning Topics : Map the ER model designed in module II to relational schema. IV. Structured Query Language (SQL) & Indexing Overview of SQL, Data Definition Commands, Set Operations, Aggregate Function, null values, Data Manipulation commands, Data Control commands, Complex Retrieval Queries using Group By Recursive Queries, nested Queries, Integrity constraints in SQL. Database Programming with JDBC, Security and authorization : Grant & Revoke in SQL Functions and Procedures in SQL and cursors. Indexing : Basic Concepts, Ordered Indices, Index Definition in SQL. (Chapter - 4) Self-learning Topics : Physical design of database for the relational model designed in module III and fire various queries. V. Relational Database Design Design guidelines for relational Schema, Functional Dependencies, Database tables and normalization, The need for normalization, The normalization process, Improving the design, Definition of Normal Forms - 1NF, 2NF, 3NF & The Boyce-Codd Normal Form (BCNF). (Chapter - 5) Self-learning Topics : Consider any real-time application and normalization up to 3NF/BCNF. VI. Transactions Management and Concurrency and Recovery Transaction : Transaction concept, State Diagram, ACID Properties, Transaction Control Commands, Concurrent Executions, Serializability - Conflict and View, Concurrency Control : Lock-based-protocols, Deadlock handling Timestamp-based protocols, Recovery System : Recovery Concepts, Log based recovery. (Chapter - 6) Self-learning Topics : Study the various deadlock situations which may occur for a database designed in module V. Note : No questions will be asked in the end-semester exam from self-study topics. However, students are encouraged to explore these topics for a better understanding of the subject.
