IT6312 DATABASE MANAGEMENT SYSTEMS LABORATORY L T P C
0 0 3 2
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 commands
- Familiarize advanced SQL queries.
- Be Exposed to different applications
LIST OF EXPERIMENTS:
- Creation of a database and writing SQL queries to retrieve information from the database.
- Performing Insertion, Deletion, Modifying, Altering, Updating and Viewing records based on conditions.
- Creation of Views, Synonyms, Sequence, Indexes, Save point.
- Creating an Employee database to set various constraints.
- Creating relationship between the databases.
- Study of PL/SQL block.
- Write a PL/SQL block to satisfy some conditions by accepting input from the user.
- Write a PL/SQL block that handles all types of exceptions.
- Creation of Procedures.
- Creation of database triggers and functions
- Mini project (Application Development using Oracle/ Mysql )
- a) Inventory Control System.
- b) Material Requirement Processing. c) Hospital Management Syst
- d) Railway Reservation System. e) Personal Information System.
- f) Web Based User Identification System. g) Timetable Management Syst
- h) Hotel Management System
REFERENCE:
spoken-tutorial.org
OUTCOMES:
At the end of the course, the student should be able to:
- Design and implement a database schema for a given problem-domain
- Populate and query a database
- Create and maintain tables using PL/SQL.
- Prepare reports.
LIST OF EQUIPMENT FOR A BATCH OF 30 STUDENTS HARDWARE:
Standalone desktops 30 Nos. (or)
Server supporting 30 terminals or more.
SOFTWARE:
Front end: VB/VC ++/JAVA or Equivalent
Back end: Oracle / SQL / MySQL/ PostGress / DB2 or Equivalent
TOTAL: 45 PERIODS
#################################################################################################
Post a Comment Blogger Facebook