Scribd
Upload
48 views11 pages

Dbms Lab File Format

This document contains a practical file for a Database Management Systems lab course. It includes an index listing 10 experiments covering topics like installing databases, creating entity relationship diagrams, using data definition commands, implementing constraints, manipulating tables, joins, subqueries, indexes, views, PL/SQL, cursors and triggers. Each experiment section provides the name, course details and space to record the date and remarks. This file was submitted by a student to their instructor for the course.

Uploaded by

shagunverma039
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
48 views11 pages

Dbms Lab File Format

This document contains a practical file for a Database Management Systems lab course. It includes an index listing 10 experiments covering topics like installing databases, creating entity relationship diagrams, using data definition commands, implementing constraints, manipulating tables, joins, subqueries, indexes, views, PL/SQL, cursors and triggers. Each experiment section provides the name, course details and space to record the date and remarks. This file was submitted by a student to their instructor for the course.

Uploaded by

shagunverma039
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 11

(Department of Computer Science and Engineering)

Practical File
of

Compiler Designing Lab.


(Subject Code: KCS-552)

Submitted to Submitted by
Dr. Rajesh,
Assistant Professor, Dept. of CSE, B. Tech. (CSE)- V – A-G1
IIMT College of Engineering, Roll no:____________________
Greater Noida-201306 Session : 2023-24

(Department of Computer Science & Engineering)


IIMT College of Engineering, Gr Noida
Plot No. 20, Knowledge Park III, Greater Noida, Uttar Pradesh 201310
Affiliated to
Dr. A. P. J. Abdul kalam Technical University, Lucknow, UP
INDEX
Page
Date of Date of
SL Name of Experiment no Remarks
Experiment Remarks

1 Installing oracle/ MYSQL

Creating Entity-Relationship Diagram using


2
case tools.

Data types in SQL and usage of various Data


3
Definition Language commands

To implement constraints on database and


4
table.

5 To Manipulate the Operations on the table

To implement the concept of Joins and


6
grouping of Data

7 To implement the concept of SubQueries

To implement the concept of Indexes and


8
views

9 To implement the basics of PL/SQL

To implement the concept of Cursor and


10
Trigger
EXPERIMENT NO. 1
Name of Experiment: Installing oracle/ MYSQL
Course Name: DBMS Lab Course Code: KCS-551
Branch: CSE Semester: V

Date of Experiment: Faculty: Mr. Badal Bhushan


EXPERIMENT NO. 2
Name of Experiment: Creating Entity-Relationship Diagram using case tools.
Course Name: DBMS Lab Course Code: KCS-551
Branch: CSE Semester: V

Date of Experiment: Faculty: Mr. Badal Bhushan

EXPERIMENT NO. 3
Name of Experiment: Data types in SQL and usage of various Data Definition Language commands
Course Name: DBMS Lab Course Code: KCS-551
Branch: CSE Semester: V
Faculty: Mr. Badal Bhushan
Date of Experiment:

EXPERIMENT NO. 4
Name of Experiment: To implement constraints on database and table.
Course Name: DBMS Lab Course Code: KCS-551
Branch: CSE Semester: V

Date of Experiment: Faculty: Mr. Badal Bhushan


EXPERIMENT NO. 5
Name of Experiment: To Manipulate the Operations on the table
Course Name: DBMS Lab Course Code: KCS-551
Branch: CSE Semester: V
Date of Experiment: Faculty: Mr. Badal Bhushan

EXPERIMENT NO. 6
Name of Experiment: To implement the concept of Joins and grouping of Data
Course Name: DBMS Lab Course Code: KCS-551
Branch: CSE Semester: V

Date of Experiment: Faculty: Mr. Badal Bhushan


EXPERIMENT NO. 7
Name of Experiment: To implement the concept of SubQueries
Course Name: DBMS Lab Course Code: KCS-551
Branch: CSE Semester: V

Date of Experiment: Faculty: Mr. Badal Bhushan


EXPERIMENT NO. 8
Name of Experiment: To implement the concept of Indexes and views

Course Name: DBMS Lab Course Code: KCS-551


Branch: CSE Semester: V

Date of Experiment: Faculty: Mr. Badal Bhushan


EXPERIMENT NO. 9
Name of Experiment: To implement the basics of PL/SQL
Course Name: DBMS Lab Course Code: KCS-551
Branch: CSE Semester: V

Date of Experiment: Faculty: Mr. Badal Bhushan


EXPERIMENT NO. 10
Name of Experiment: To implement the concept of Cursor and Trigger
Course Name: DBMS Lab Course Code: KCS-551
Branch: CSE Semester: V

Date of Experiment: Faculty: Mr. Badal Bhushan

You might also like