MEERUT INSTITUTE OF ENGINEERING & TECHNOLOGY
DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING
DATABASE MANAGEMENT SYSTEMS (KCS 551)
List of Experiments
Exp.
No.
Experiment Name
Course
Outcome
1
Write SQL queries for Data Definition Language.
Create Table, Alter Table,Drop Table,Truncate
CO1
2
Write SQL queries for Data Manipulation Language.
Insert, Select, Update ,Delete
CO1
3
Write SQL queries to implement integrity constraints in the relations.
CO1
4
a) Write SQL queries using arithmetic operators (=, <, >, etc)
b) Write SQL queries using logical operators (AND, OR, BETWEEN,
NOT, etc)
CO2
5
Write SQL queries using built in aggregate, scalar, numeric and string functions.
CO2
6
a) Write SQL queries for extracting data from more than one table (use of joins)
b) Write SQL queries using nested queries and SET operators.
CO3
7
a) Write control structure programs in PL/SQL.
b) Create procedure and function in PL/SQL.
CO4
8
Create cursor in PL/SQL.
Create triggers in PL/SQL.
CO4
Value added Programs
9.
Creating different types of index using SQL
CO1
10.
Create, rename, select, update & drop views in SQL.
CO1
Lab Incharge Head(CSE)
