DATA BASE MANAGEMENT MADRAS UNIVERSITY SYLLABUS

Title of the Course/	Paper - X - DATABASE MANAGEMENT SYSTEMS
Core	III Year & Fifth Semester	Credit: 4
Objective of the course	This course introduces the basic concepts of database management systems
Course outline	Unit 1: 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-2:  Query Basics – Computation Using Queries – Subtotals and GROUP BY Command – Queries with Multiple Tables – Subqueries – Joins – DDL & DML – Testing Queries
	Unit 3: 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-4:  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-5 : 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.

 Recommended Texts

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

 Reference Books

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.