Overview
AIM:
The aim of this laboratory is to inculcate the abilities of applying the principles of the database
management systems. This course aims to prepare the students for projects where a proper
implementation of databases will be required.
OBJECTIVES:
ï‚· To understand data definitions and data manipulation commands
ï‚· To learn the use of nested and join queries
ï‚· To understand functions, procedures and procedural extensions of data bases
ï‚· To be familiar with the use of a front end tool
ï‚· To understand design and implementation of typical database applications
1. Data Definition Commands, Data Manipulation Commands for inserting, deleting, updating
and retrieving Tables and Transaction Control statements
2. Database Querying – Simple queries, Nested queries, Sub queries and Joins
3. Views, Sequences, Synonyms
4. Database Programming: Implicit and Explicit Cursors
5. Procedures and Functions
6. Triggers
7. Exception Handling
8. Database Design using ER modeling, normalization and Implementation for any application
9. Database Connectivity with Front End Tools
10. Case Study using real life database applications
TOTAL: 60 PERIODS
OUTCOMES:
Upon completion of the course, the students will be able to:
ï‚· Use typical data definitions and manipulation commands.
ï‚· Design applications to test Nested and Join Queries
ï‚· Implement simple applications that use Views
ï‚· Implement applications that require a Front-end Tool
ï‚· Critically analyze the use of Tables, Views, Functions and Procedures
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 a 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 System.
d) Railway Reservation System.
e) Personal Information System.
f) Web Based User Identification System.
g) Timetable Management System.
h) Hotel Management System
Course Features
- Lectures 11
- Quizzes 0
- Students 2
- Assessments Yes
Curriculum
-
Lab Experiments
- DDL Commands in Database Management System Lab
- SQL Constraints in Database Management System Lab
- DML COMMANDS in Database Management System Lab
- SQL RELATIONSHIP -NESTED QUERIES & JOIN QUERIES
- CREATION OF VIEWS with SYNONYMS and SEQUENCE
- PL/SQL FUNCTIONS
- PL/SQL TRIGGER Using CURSOR
- PL/SQL EXCEPTION HANDLING
- Inventory Control System using Oracle
- Material Requirement Processing using Oracle
- Hospital management System Using Oracle
Instructor
