Syllabus Relational Database Management Systems - (MC01094031) 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, Mapping EER model construct to Relations. (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. Transaction processing Introduction to Transaction Processing Concepts : Introduction to Transaction Processing, Transaction and System concepts, Desirable properties of Transactions, characterizing Schedules based on recoverability and Serializability Relational Model concepts : Relational Model concepts, Relational Model constraints and Relational Database Schemas. (Chapter - 4) 5. (οͺ) SQL Concepts Basics of SQL, DDL, DML, DCL, structure - creation, alteration, defining constraints - Primary key, foreign key, unique, not null, check, IN operator, Functions - aggregate functions, Built-in functions - numeric, date, string functions, set operations, sub-queries, correlated sub-queries, Use of group by, having, order by, join and its types, Exist, Any, All, view and its types. transaction control commands - Commit, Rollback, Savepoint. (Chapter - 5) (*) : Only Higher order questions / application oriented questions to be asked in the theory exam from Unit 5.
