Scribd
Upload
18 views9 pages

DBMS Lab 1

This document contains a lab assignment on database management systems. It involves creating tables, inserting data, retrieving data through queries, updating, deleting and altering table structures. The tables created are CLIENT_MASTER to store client data, PRODUCT_MASTER to store product data, and SALESMAN_MASTER to store salesman data. Queries are written to perform various operations on these tables.

Uploaded by

Dustin Henderson
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
18 views9 pages

DBMS Lab 1

This document contains a lab assignment on database management systems. It involves creating tables, inserting data, retrieving data through queries, updating, deleting and altering table structures. The tables created are CLIENT_MASTER to store client data, PRODUCT_MASTER to store product data, and SALESMAN_MASTER to store salesman data. Queries are written to perform various operations on these tables.

Uploaded by

Dustin Henderson
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

Prathmesh Bansal 0801IT201067

SHRI G.S. INSTITUTE OF TECHNOLOGY & SCIENCE,


INDORE

Department of Information Technology

Subject Code: IT-38513


Subject Name: Database Management System

Lab Assignment 1

Name: Instructor:
Prathmesh Bansal Mukesh Sakle Sir
Enrollment Number:
0801IT201067

1
Prathmesh Bansal 0801IT201067

Que.1: Create the table describe below:


a. Table: CLIENT_MASTER
Description: Used to store client information

b. Table: PRODUCT_MASTER
Description: Used to store product information

2
Prathmesh Bansal 0801IT201067

c. Table: SALESMAN_MASTER
Description: Used to store salesman information working for the company

3
Prathmesh Bansal 0801IT201067

Que.2: Insert the following data into their respective tables:


a. Table Name: CLIENT_MASTER

4
Prathmesh Bansal 0801IT201067

b. Table Name: PRODUCT_MASTER

c. Table Name: SALESMAN_MASTER

Que.3: Exercise on retrieving records from table:


a. Find out the names of all clients.

5
Prathmesh Bansal 0801IT201067

b. Retrieve the entire contents of the Client_master table.

c. Retrieve the list of names, city, and the state of all clients.

d. List the various products available from the Product_Master table.

e. List all the clients who are located in Mumbai.

6
Prathmesh Bansal 0801IT201067

f. Find the names of salesmen who have a salary equal to Rs. 3000.

Que.4: Exercise on updating records in the table:


a. Change the city of ClientNo 'C00005' to 'Bangalore'.

b. Change the Baldue of ClientNo 'C00001' to Rs. 1000.

c. Change the cost price of 'Trousers' to Rs. 950.00.

7
Prathmesh Bansal 0801IT201067

d. Change the city of salesmen to 'Pune'.

Que.5: Exercise on deleting records in the table:


a. Delete all salesmen from the Salesman_Master whose salary are equal to 3500.

b. Delete all products from Product_Master where the quantity on hand is equal to 100.

c. Delete from Client_Master where the column state holds the value 'Tamilnadu'.

8
Prathmesh Bansal 0801IT201067

Que.6: Exercise on altering the table structure:


a. Add a column called 'Telephone' of datatype 'number' and size = '10' to the
Client_Master table.

b. Change the size of the SellPrice column in Product_Master to 10,2.

Que.7: Exercise on deleting the table structure along with its data:
a. Destroy the table Client_Master along with its data.

Que.8: Exercise on renaming the table:


a. Change the name of the Salesman_Master table to Sman_Mast.

You might also like