Scribd
Upload
18 views8 pages

SQL Assignment

Uploaded by

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

SQL Assignment

Uploaded by

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

A.

Create the 3 tables as shown in Slide 1 - Note that Red colour is Primary Key and
Green Colour is Foreign key

Eg

1. Customers
2. Orders
3. Products
b. Display structure of the 3 tables
c. Enter the data as mentioned in the slide in the
3 tables
d. Write command to display emp_id,
emp_name, gender for employees drawing salary
> 15,00,000
e. Write command to display data for all Female
employees

f. Add data for mgr_id = 3 in branch table


considering the relevant,appropriate and logical
data
g. Change the NULL value of mgr_id to 104 for
emp_id 101

h. Display the data in Client table grouped by


branch_id
I. Display male employees who salary >10,00,000

j. Do an inner join on table Employee and Branch


using the relevant field

You might also like