UNIVERSITY OF MADRAS
B.Sc. DEGREE COURSE IN COMPUTER SCIENCE
SEMESTER SYSTEM WITH CREDITS
(Effective from the Academic Year 2003-2004)

Semester V - Paper IX - CS321 - Database Management System

Lecture Lab: 6
Duration: 3 hrs
Maximum Marks: 100
Credits: 4

UNIT - I:

Advantages and Components of a Database Management Systems - Feasibility Study - Class Diagrams - Data Types - Events - Normal Forms - Integrity - Converting Class Diagrams to Normalized Tables - Data Dictionary.

UNIT - II:

Query Basics - Computation Using Queries - Subtotals and GROUP BY Command - Queries with Multiple Tables Subqueries - Joins - DDL & DML - Testing Queries.

UNIT - III:

Effective Design of Forms and Reports - Form Layout - Creating Forms - Graphical Objects - Reports -- Procedural Languages - Data on Forms - Programs to Retrieve and Save Data - Error Handling.

UNIT - IV:

Power of Application Structure - User Inteiface Features - Transaction -- Forms Events - Custom Reports - Distributing Application - Table Operations - Data Storage Methods - Storing Data Columns - Data Clustering and Partitioning.

UNIT - V:

Database Administration - Development Stages - Application Types - Backup and Recovery - Security and Privacy - Distributed Databases - Client/Server Databases - Web as a Client/Server System - Objects - Object Oriented Databases - Integrated Applications.

Text:

1. G. V. Post - Database Management Systems Designing and Building Business Application - McGraw Hill International edition - 1999.

References:

1. Raghu Ramakrishnan - Database Management Systems - WCB/McGraw Hill - 1998.
2. C.J. Date - An Introduction to Database Systems - 7^th Edition - Addison Wesley - 2000.