1 of 9

G H RAISONI COLLEGE OF ENGINEERING AND MANAGEMENT

(Approved by AICTE, New Delhi and Recognized by DTE, Maharashtra)

An Autonomous Institute & Affiliated to Rashtrasant Tukadoji Maharaj Nagpur University, Nagpur

Accredited by NAAC with A+ Grade

Department of Artificial Intelligence

Block C

2^nd Floor

Room No C-2-02

DATABASE LAB

2 of 9

Outline

About Laboratory
List of Major Equipment / Software-Hardware Configuration
Laboratory Course Outcome
List of Experiments
Details of Funded Laboratory/ Projects (if any)
Glimpses of Laboratory

3 of 9

About Laboratory

Information about Laboratory: The aim of the Database Lab in the Artificial Intelligence department is to provide students with a dedicated and well-equipped space to effectively conduct their database management practicals. This lab will support hands-on learning and experimentation with various database technologies and methodologies. By facilitating access to essential tools and resources, the lab aims to enhance students’ understanding of database concepts, improve their technical skills, and prepare them for real-world applications in data management and artificial intelligence. The department is equipped with Database laboratory with an area of 68.37 SQM. which has been established with well equipped systems of latest hardware configuration and modern open source software technologies.

4 of 9

List of Major Equipment / Software-Hardware Configuration

Sr. No.	EQUIPMENT	QUANTITY
1	COMPUTER (LENOVO DESKTOP with specification 12th Gen Intel(R) Core(TM) i5-12400 2.50 GHz, 8.00 GB Ram, 512 SSD)	22
2	CASSING & CUPING	--
3	COMPUTER TABLE	24
4	COMPUTER CHAIR	24
5	ELECTRIC FITTING	--

5 of 9

Laboratory Course Outcome

Name of Subject:	DATABASE MANAGEMENT SYSTEM
LABORATORY COURSE OUTCOME
CO1	Student will be able to analyze an information storage problem and derive an information model expressed in the form of an entity relation diagram and other optional analysis forms and design appropriate data model for it
CO2	Student will be able to demonstrate an understanding of various normalization forms and apply knowledge of normalization for creation of database.
CO3	Students will be able to demonstrate SQL queries to perform Create, Retrieve, Update, Delete operations on database and perform inferential analysis of data model.
CO4	Students will be able to demonstrate query processing and able to design optimized query execution plan
CO5	Students will be able to perform basic transaction processing and management and ensure database security, integrity and concurrency control.

6 of 9

List of Experiments

Sr. No.	Experiment List
1	Write a SQL statement to implement Data Definition Language commands.
2	Write a SQL statement to implement Data Manipulation Language commands.
3	Write a SQL statement to implement various types of integrity constraints.
4	Write a SQL statement to implement inbuild functions & SET operations in SQL.
5	Write a SQL statement to implement group by, order by & having clause.
6	Write a SQL statement to implement join queries.
7	Write a SQL statement to implement sub queries.
8	Write a SQL statement to implement views for the application created.
9	To make use of transaction control statements viz rollback, commit and savepoint.

7 of 9