Notes on Database Management Systems
STELLA MARIS COLLEGE - DEPARTMENT OF COMPUTER SCIENCE
DB34 - Database Management Systems
UNIT I :
Advantages and Components of a Database Management Systems - Feasibility Study - Class Diagrams - Data Types –Architecture- Events - Normal Forms - Integrity – EER model - 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:
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 - 7th Edition - Addison Wesley - 2000.
Application Oriented Subject I- RD44 RDBMS
Basic concepts of Relational Data model – introduction to SQL-Normalization. Creating tables –data types-date functions-conversion and transformation functions-queries and subqueries.
Changing data-advanced use of functions and variables-creating, dropping, altering tables and views-SQL plus – accessing Remote data-building reports –authority allocation – triggers and procedures. Data dictionary-design
DB34 - Database Management Systems
UNIT I :
Advantages and Components of a Database Management Systems - Feasibility Study - Class Diagrams - Data Types –Architecture- Events - Normal Forms - Integrity – EER model - 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:
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 - 7th Edition - Addison Wesley - 2000.
Application Oriented Subject I- RD44 RDBMS
Basic concepts of Relational Data model – introduction to SQL-Normalization. Creating tables –data types-date functions-conversion and transformation functions-queries and subqueries.
Changing data-advanced use of functions and variables-creating, dropping, altering tables and views-SQL plus – accessing Remote data-building reports –authority allocation – triggers and procedures. Data dictionary-design
References: 1. Gary W. Hanson and James V. Hanson, Database Management and Design, Prentice Hall of India Pvt Ltd, 1999. 2. Alex Benson, Stephen Smith and Kurt Thearling, Building Data Mining Applications for CRM, Tata McGraw-Hill, 2000. URL : http://www.indiastudycenter.com/Other/Syllabus/AnnUniv/PG/MCA/MC1626-Advanced-Databases.asp