UNIVERSITY OF MADRAS
Bachelor in Computer Applications (BCA)
SEMESTER SYSTEM WITH CREDITS
(Effective from the Academic Year 2003-2004)

SYLLABUS

Semester V - BCA318 - Database Management Systems

Lecturer/Lab Hours per Week: 6
Duration: 3 hrs
Max Makrs: 100
Credit: 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 - Objects - Object Oriented Databases - Integrated Applications.

Reference: