ANNA UNIVERSITY, CHENNAI

AFFILIATED INSTITUTIONS

R-2017

B.E. COMPUTER SCIENCE AND ENGINEERING

CS8492 - DATABASE MANAGEMENT SYSTEMS LAB

OBJECTIVES:

The student should be made to:

• Learn to create and use a database
• Be familiarized with a query language
• Have hands-on experience on DDL Commands
• Have a good understanding of DML Commands and DCL command
• Familiarize advanced SQL queries
• Exposed to different applications

LIST OF EXPERIMENTS

1. Creation of a database and writing SQL queries to retrieve information from the database.
2. Performing Insertion, Deletion, Modifying, Altering, Updating and Viewing records based on conditions.
3. Creation of Views, Synonyms, Sequence, Indexes, save point.
4. Creating an Employee database to set various constraints.
5. Creating a relationship between the databases.
6. Study of PL/SQL block.
7. Write a PL/SQL block to satisfy some conditions by accepting input from the user.
8. Write a PL/SQL block that handles all types of exceptions.
9. Creation of Procedures.
10. Creation of database triggers and functions
11. Mini project (Application Development using Oracle/ Mysql )

a) Inventory Control System.

b) Material Requirement Processing.

c) Hospital Management System.

d) Railway Reservation System.

e) Personal Information System.

f) Web Based User Identification System.

g) Timetable Management System.

h) Hotel Management System