DATABASE MANAGEMENT SYSTEMS
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 – 7th Edition – Addison Wesley - 2000.