Unit IIntroduction to DBMS Introduction: Basic concepts, Advantages of DBMS over file processing systems, Data abstraction, Database languages, Data models, Data independence, Components of a DBMS, Overall structure of DBMS, Multi-user DBMS architecture, System catalogs, Data Modeling: Basic concepts, Entity, attributes, relationships, constraints, keys. (Chapter - 1) Unit IIRelational Model ER and EER diagrams: Components of ER model, Conventions, Converting ER diagrams into tables. Relational Model: Basic concepts, Attributes and Domains, Codd’s rules. Relational Integrity: Nulls, Entity, Referential integrities, Enterprise constraints, Views, Schema diagram. (Chapter - 2) Unit IIIIntroduction to SQL - PL/SQL Introduction to SQL: Characteristics and advantages SQL Data Types, Literals, DDL, DML, SQL Operators Tables: Creating, Modifying, Deleting, Views: Creating, Dropping, Updation using Views, Indexes, Nulls. SQL DML Queries: SELECT query and clauses, Set operations, Tuple Variables, Set comparison, Ordering of Tuples, Aggregate Functions, Nested Queries, Database Modification using SQL Insert, Update, Delete Queries, Stored Procedure, Triggers, Programmatic SQL: Embedded SQL, Dynamic SQL, ODBC. (Chapter - 3) Unit IVDatabase Design & Query Processing Relational Databases Design: Purpose of Normalization, Data Redundancy and Update Anomalies, Functional Dependencies. The process of Normalization: 1NF, 2NF, 3NF, BCNF. Unit VTransaction & Concurrency Control Transaction Management: Basic concept of a Transaction, Properties of Transactions, Database Architecture, Concept of Schedule, Serial Schedule. Unit VIAdvanced Databases
