Scribd
Upload
72 views4 pages

SQL Plus: Dav Institute of Management Practical File OF Database Management System (DBMS) Based On

The document is an index for a database management system practical file submitted by Damodar Sharma. It contains 40 assignments related to creating, modifying and querying various database tables using SQL. The assignments involve creating tables for clients, products, employees and orders and performing queries on these tables to retrieve, update, delete and aggregate data.

Uploaded by

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

SQL Plus: Dav Institute of Management Practical File OF Database Management System (DBMS) Based On

The document is an index for a database management system practical file submitted by Damodar Sharma. It contains 40 assignments related to creating, modifying and querying various database tables using SQL. The assignments involve creating tables for clients, products, employees and orders and performing queries on these tables to retrieve, update, delete and aggregate data.

Uploaded by

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

DAV INSTITUTE OF MANAGEMENT

PRACTICAL FILE
OF
DATABASE MANAGEMENT SYSTEM(DBMS)
BASED ON

SQL PLUS

SUBMITTED TO: SUBMITTED BY :

MS. GEETIKA KHURANA Damodar Sharma

SUBJECT FACULTY COURSE: BBA (II),4th Sem

UNIVERSITY REG. NO.:

1611030373
Index

S no. Assignment Page Remark


No.
1 Create a Table of Client_Master with Name, Salary & 1,2,3
City.

2 Create a Table of Product with Name, Sell-Price & 4


Quantity.

3 Create a Table of Client with Name, address, 5,6


designation &phone_no with mention the city &
state name .

4 Create an employees table. 7,8

5 Create an orders table. 9,10

6 Modify Orders table add and update price column. 11,12

7 Find the names of all clients having ‘a’ as the first 13


letter in their names.

8 Find the cities of all clients having ‘m’ as the first 14


letter in their cities.

9 Find the list of all the clients whose salary is more 15


than 1000.

10 Determine the minimum & maximum price of the 16


product.

11 Find the date 15 days after today’s date. 17


S no. Assignment Page Remark
No.
12 Count the no. of products (Quantity) whose price is 18
more than 5000.

13 Calculate the average price of all the product. 19

14 Find the name & complete address of the client. 20

15 Find the Product & Quantity placed by 001 & 002. 21

16 List the client with their address, designation and 22


phone no.

17 List the client details using left out join. 23,24

18 List the client details along with contact details using 25


right outer join.

19 Retrieve the clients working of the manager post. 26

20 Retrieve Name, Quantity, and Code from product 27


table whose product_id=301.

21 Retrieve Name, Address, and City from client table 28


whose client_id=1001.

22 List the name of clients who has placed order worth 29


rupees 75000.

23 Find out the name of all the clients. 30

24 Retrieve the entire content of client table. 31

25 Retrieve the list of name, city of the client. 32

26 List the clients are located on Ratlam. 33

27 Change the city of client 1003 to Bengaluru. 34

28 Change the balance view of 1003 Rs 1000. 35

29 Delete one client where the column city hold where 36


the Bengaluru.
S no. Assignment Page Remark
No.
30 Modify the table Client_Master by adding a new 37,38
column Ph_No .

31 Delete the table. 39

32 Change the name of client table Client_CF. 40

33 Retrieve Order_No, State, Cusname, Product_No 41


from Orders.

34 Write a command of save the data & table in SQL. 42

35 Write a command of find the next day date of present 43


date in SQL.

36 Write a command of find the moths of difference of 44


date in SQL.

37 Write a command of round the date in SQL. 45

38 Write a command of add months in present month in 46


SQL.

39 Write a command of find the last date of Sysdate in 47


SQL.

40 Write a command of undo your table in SQL. 48

You might also like