School of Computer Applications and
Technology
Program: BCA
Course Name: Database Management System Lab Course
Code: E1UA211
Sr.No
.
Title of Lab Experiments (BCA SEM II)
1 Implement Data Definition Language Statements.
2 Implement Data Manipulation Statements.
3 Implement SELECT command with different clauses.
4 Implement various type of Integrity Constraints on database.
5 Implement SINGLE ROW functions (Character, Numeric, Date
functions) and GROUP functions (avg, count,max, min, sum).
6 Implement various type of SET OPERATORS (Union, Intersect, Minus)
and JOINS.
7 Implement the concept of grouping of Data and Subqueries.
8 Implement the concept of Data Control Language (DCL).
9 Implement the concept of Transaction Control Language (TCL).
10 Implement the following function: MAX(), MIN(), AVG(), COUNT()
11 Implement the constraints like primary key, foreign key, Not Null to
the table.
12 Implement Simple and Complex View.
13 Create a Database for Banking Sector and implement various queries
on it.
14 Create a Database for Customer Sale/purchase and implement various
queries on it.
15 Create Indexes and save point.
