Syllabus Database Management System - (BC02001021) Total Credits L+T+(PR/2) Assessment Pattern and Marks Total Marks C Theory Tutorial / Practical ESE (E) PA / CA (M) PA / CA (I) ESE (V) 4 70 30 20 30 150 Unit No. Content 1. Introduction to Database System Database and Users : Introduction (Basic Concepts : Data, Database, Database systems, Database Management Systems), Characteristics of Database Approach, Actors on Scene, Workers behind the Scene, Advantages of using the DBMS approach Database System Concepts and Architecture : Data Models, Schemas, Instances, the three schema architectures and data independence, Database Languages and interfaces, Database System environment, Centralized and client / Server Architecture for DBMS, Classifications of Database Management Systems. (Chapter - 1) 2. Entity Relationship Diagram Using high level conceptual data models for database design (Design Phases of database design), Entity types, Entity Sets, Attributes and keys, Relationship Types, Relationship sets, Roles and structural constraints, Weak entity Types, Refining the ER diagram for company Database, Entity Relationship Diagram Naming conventions Design issues, Example of other Notation : UML class diagram, Relationship types of degree higher than 2 Subclasses, Super Classes, Inheritance Specialization and Generalization Relational Database design by ER and EER to Relational Mapping. (Chapter - 2) 3. Database Design Informal Design Guidelines for Relational Schema, Functional Dependencies, Normal Forms based on Primary keys, General definitions of 1NF, 2NF and 3NF, Boyce-Codd Normal Forms (BCNF), Multi-valued Dependency and Fourth Normal Form. (Chapter - 3) 4. Relational Model concepts : Relational Model concepts, Relational Model constraints and Relational Database Schemas Relational Algebra : Unary Relational Operations (Select and Project), Relational Algebra operations from Set Theory, Binary Relational Operations (JOIN and Division) and Additional Relational Operations (Generalized projection, aggregate functions and grouping, Recursive Closure Operations, Outer Join Operations, the outer union operation). (Chapter - 4) 5. Introduction to Transaction Processing Concepts : Introduction to Transaction Processing, Transaction and System concepts, Desirable properties of Transactions, characterizing Schedule Based on Recoverability and Serializability. (Chapter - 5)
