Name of Subject  :

DATABASE MANAGEMENT SYSTEMS (5 CS 3)

Unit

Contents

INTRODUCTION TO DATABASE SYSTEMS: Overview and History of DBMS. File System vs DBMS .Advantage of

DBMS Describing and Storing Data in a DBMS. Queries in DBMS. Transaction management and Structure of a

I

DBMS.

ENTITY RELATIONSHIP MODEL:

Overview of Data Design Entities, Attributes and Entity Sets, Relationship and

Relationship Sets. Features of the ER Model-Key Constraints, Participation Constraints, Weak Entities, Class

II

Hierarchies, Aggregation, Conceptual Data Base, Design with ER Model-Entity vs Attribute, Entity vs Relationship

Binary vs Ternary Relationship and Aggregation vs ternary Relationship Conceptual Design for a Large Enterprise.

RELATIONSHIP ALGEBRA AND CALCULUS

:

Relationship Algebra Selection and Projection, Set Operations,

III

Renaming, Joints, Division, Relation Calculus, Expressive Power of Algebra and Calculus.

SQL QUERIES PROGRAMMING AND TRIGGERS:

The Forms of a Basic SQL Query, Union, Intersection and

Except, Nested Queries ,Correlated Nested Queries, Set-Comparison Operations, Aggregate Operators, Null Values

IV

and Embedded SQL, Dynamic SQL, ODBC and JDBC, Triggers and Active Databases.

SCHEMA REFINEMENT AND NORMAL FORMS:

Introductions to Schema Refinement, Functional Dependencies,

V