7EE1 DATA BASE MANGEMENT SYSTEM

Unit-1  Introduction, need, purpose and goals of DBMS. DBMS Architecture, Concept of keys,

Generalization and specialization, introduction to relational data model, ER modeling, concept

of ER diagram.

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 algebra and relational calculus.

Unit-3 SQL, DDL and DML. Constraints assertions, views database security. Application

Development using SQL: Host Language interface, embedded SQL programming. GL’s,

Forms management and report writers. Stored procedures and triggers. Dynamic SQL, JDBC.

Unit-4

Internal of RDBMS:

Physical data organization in sequential, indexed, random and hashed

files. Inverted and multilist structures.

Unit-5

(i) Transaction Management:

Transaction concept, transaction state, serializability, conflict

serializabiltiy, view serializability.

(ii) Concurrency Control:

Lock based protocol.

(iii)

Deadlock Handling:

Prevention detection, recovery.

(iv) Recovery System:

Log based

recovery.