[go: up one dir, main page]
Scribd
Upload
9 views1 page

DBMS LAB LIST - Updated

lab list

Uploaded by

vinitchoudharyji11
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
9 views1 page

DBMS LAB LIST - Updated

lab list

Uploaded by

vinitchoudharyji11
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/ 1

Lab Name (Code): DBMS Lab (BCS-551)

Tool Used: My SQL/Oracle

List of Experiments:
1. Installing oracle/ MYSQL.
2. Creating Entity-Relationship Diagram using case tools.
3. Writing SQL statements Using ORACLE /MYSQL:
a) Writing basic SQL SELECT statements.
b) Restricting and sorting data.
c) Displaying data from multiple tables.
d) Aggregating data using group function.
e) Manipulating data.
f) Creating and managing tables
4. Creating procedure and functions.
5. Design and implementation of Student Information System.
6. Write a CURSOR to display list of clients in the client Master Table.

Experiments beyond recommendation of AKTU:

1. Execute the queries related to Group By and having Clause on tables SALES_ORDER.
2. Execute the following queries:
a) The NOT NULL
b) The UNIQUE Constraint
c) The PRIMARY KEY Constraint
d) The CHECK Constraint
e) Define Integrity Constraints in ALTER table Command
3. Execute Nested Queries on tables CLIENT_MASTER, PRODUCT_MASTER,
SALESMAN_MASTER, SALES_ORDER, SALES_ORDER_DETAILS.
4. Execute Queries related to Exists, Not Exists, Union, Intersection, Difference, Join on tables
CLIENT_MASTER, PRODUCT_MASTER, SALESMAN_MASTER, SALES_ORDER_DETAILS>

Faculty (Name & Signature): Ms. Jyoti Thakur

You might also like