4EC6.2 - DATA BASE MANAGEMENT SYSTEM

UNIT 1

:Introduction Need, purpose and goals of  DBMS. DBMS Architecture, Concept of keys,

Generalisation and specialization,  Introduction to Relational data model, ER Modeling,  Relational

algebra.

UNIT 2: DATABASE DESIGN :

Conceptual Data Base design. Theory of normalization, Primitive and

composite data types, concept of physical and logical databases, data abstraction and data

independence,. Relational calculus.

UNIT 3

: SQL : DDL and DML. Constraints assertions, views, data base security. Application

Development using SQL : Host language interface, embedded SQL programming. GL's, Forms

management and report writers. Stored procedures and triggers.

UNIT 4

INTERNAL OF RDBMS -

Physical  data  organization in  sequential, indexed,  random  and

hashed files. Inverted and multilist structures.

UNIT 5

: Transaction processing, concurrency control, Transaction model properties and state

serialisability. Lock base protocols, two phase locking, Log based recovery Management.