Madras University DBMS Syllabus

I am the student of the Madras University and require the syllabus of the Database Management Systems so can you please provide me this syllabus so that I can do my preparation of the exam according to it? Also provide me the blueprint of this subject?

[sumit]

The University of Madras or Madras University is a public state university in Chennai, Tamil Nadu, India. Established in 1857, it is one of the oldest universities in India, incorporated by an Act of Legislative Council of India under the British government.


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 - 7th Edition - Addison Wesley - 2000.


Address:

Madras University
Navalar Nagar, Chepauk, Triplicane, Chennai, Tamil Nadu 600005
Phone: 044 2539 9422