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

SYLLABUS

Semester V - BSE 301 - Database Management Systems

Lecture Per Week: 6 hrs
Duration of Examination: 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 Interface 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 - Object Oriented Databases - Integrated Applications.

Books for Study and References:

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

2. Raghu Ramakrishnan - Database Management Systems - WCB/McGraw Hill - 1998.

3. C.J. Date - An Introduction to Database Systems - 7^th Edition - Addison Wesley - 2000.