UNIT I

INTRODUCTION

12

Database Systems - An Over View - Meaning, Definition - Components - Objectives - Advantages and Disadvantages - Evolution

UNIT II

MODELS

DBMS Architecture - Associations - Relationship - Generalization - Classifications - Conceptual Data Modeling - File Organization

UNIT III

DATABASE DESIGN

12

Relational Data Model - ER Diagram - Data Dictionary - Normalization - Boyce Codd Normal Form - Integrity - Relational Database Languages - Database Administration

UNIT IV

OBJECT MODELING

12

Object Oriented Concepts - Structure - Models and Database - Object Lifecycle Modeling - Object Oriented Design

UNIT V

OPERATIONS and MANAGEMENT                                                                      

12

Client / Server and Databases - Data Warehousing - Query Processing - Heterogeneous and Homogeneous - Distributed Databases - Controls

                                                                                                                                          TOTAL: 60

TEXT BOOKS:

Sl.No.

Author(s)

Title of the Book

Publisher

Year of

Publication

1.

Gary W Hansen and

James V Hansen

Database Management

and Design

Prentice Hall

 of India

2004

2.

Jeffrey A Hoffer, Mary B Perscott, Fred R Mcfadden

Modern

Management

Prentice Hall

of India

2002

REFERENCE BOOKS:

Sl.No.

Author(s)

Title of the Book

Publisher

Year of

Publication

1.

Bobin C Desai

An Introduction to Database Systems

Galfothia Publications

1996

2.

Ronald J Norman

Object Oriented Systems Analysis and Design

Prentice Hall

of India

1996

3.

Elmasri - Navathe

Fundamentals of Database Systems

Addtision - Wesley

1995

4.

Carlo Batini,

Stefano Ceri and

Sham Kant B Navathe

Conceptual Database Design - An ER Approach

Benjamin Cummings Publishing

1992

5.

James Rumbaugh, Michael Blake,

William Lorensen, Frederick Eddy and Willam Premelani

Object Oriented Modeling and Design

Prentice Hall

 of India

1991

WEB URLs:

•  www.iwebtool.com

•  www.dbmsmag.com