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.