Module 1

Introduction to DBMS - View of data - Data Models - Languages - Different types

of DatabaseSystems - Database administration - Database users

Module 2

Data Models- E-R Model -. Concepts, Design issues - E-R Diagrams - Entity sets

- Design of E-R databased ~chema -- Reduction of Schema to tables - Relational

Models- Structure of Relational Database - Relational Algebra

Module 3

 SQL- Basic structure, operations, functions, queries - Derived rolations - DDL.

Modification of Database Transaction Concepts - States – Concurrency control

 Query optimization

Module 4

Relational Database Design - Pitfalls in relational Database Design -

 .Decomposition- Normalization - Normalization techniques - Domain key normal

form and alternative approaches to database design - Database backup and """ -

recovery

Module 5

:: Emerging trends in Database Management - Object oriented databases -

 Decision support systems - Data Mining - Data warehousing - Multimedia

databases - Geographic databases – Distributed Information Systems ·