| Unit-I Introduction of DBMS, Data Modeling for a Database, Three level Architecture of DBMS, Components of a DBMS. Introduction to Data Models, Hierarchical, Network and Relational Model, Comparison of Network, Hierarchical and Relational Model, Entity Relationship Model. |
| Unit-II Relational Database, Relational Algebra and Calculus, SQL Fundamentals, DDL, DML, DCL, PL/SQL Concepts, Cursors, Stored Procedures, Stored Functions, Database Triggers. |
| Unit-III Introduction to Normalization, First, Second, Third Normal Forms, Dependency Preservation, Boyce-Codd Normal Form, Multi-valued Dependencies and Fourth Normal Form, Join Dependencies and Fifth Normal Form, Domain-key normal form (DKNF). |
| Unit-IV Database Recovery, Concurrency Management, Database Security, Integrity and Control. Structure of a Distributed Database, Design of Distributed Databases. |