[go: up one dir, main page]

0% found this document useful (0 votes)
85 views5 pages

DBMS LAB (KCS-501) : Piyush Bansal

Download as pdf or txt
Download as pdf or txt
Download as pdf or txt
You are on page 1/ 5

DBMS LAB (KCS-501)

Name: PIYUSH BANSAL

Roll No: 1803013061

Year/Branch: B.tech 3rd yr / IT (A)

Submitted To:
Dr.Monika
Sainger

Ms.Preeti
Sharma

PIYUSH BANSAL 1803013061


ASSIGNMENT - 2

1. Insert five records in table student_details.


2. Insert five records in Product table with one INSERT INTO
command.
3. Display the structure of both tables.
4. Create a database ‘Dbase’. Give the command to seethe
same in list of databases.
5. Drop the database ‘Dbase’.
6. Display the records entered in table student_details.
7. Display the records in table product.
8. Display the name of students.
9. Display the product names with their quantity.

PIYUSH BANSAL 1803013061


PIYUSH BANSAL 1803013061
PIYUSH BANSAL 1803013061
PIYUSH BANSAL 1803013061

You might also like