Blog: CS403 Assignment No. 4 (June 2011) - solution soon

Assignment No. 04
Semester Spring2011
Database Management Systems-CS403


Total Marks: 15
Due Date: 20/06/2011

Objective: To learn and understand basic concepts of SQL statements with the emphasis on “where” clause. Instructions: Please read the following instructions carefully before solving & submitting assignment: It should be clear that your assignment will not get any credit (marks) if: The assignment is submitted after due date. The submitted assignment does not open or file corrupt. The submitted assignment is in the format other than MS Word (doc). The assignment is copied (from other student or copy from handouts). Student ID is not mentioned in the assignment File or name of file is other than student ID.  For any query about the assignment, contact at cs403@vu.edu.pk

Q 1:  Write SQL statements/queries to show the data for each of individual scenario given below from the given tables on the next page. 15 marks (3+3+3+3+3)

1. Show all the Category names with their Supplier names.
2. Show all the names of Products with their IDs.
3. Show all the products of “Bumper & Components” Category.
4. Show all the Product names and their Supplier names.
5. Show all those Product IDs supplied by “S & S corporations”.

“You will have to give the reason, If the query for any of above statement cannot execute”

Product

Product ID	Product Name	Category ID
PID-1	Bumper Cover	CT-1
PID-2	Bumper	CT-1
PID-3	Fender	CT-2
PID-4	Mirrors	CT-3
PID-5	Hood	CT-4

Category

Category ID	Category Name	Supplier ID
CT-1	Bumper & Components	SP-1
CT-2	Fenders & Components	SP-2
CT-3	Mirrors & Components	SP-2
CT-4	Hoods & Components	SP-3

       

Supplier

Supplier ID	Supplier Name
SP-1	S & S corporations
SP-2	AB Hardwares
SP-3	CG Brothers

Guidelines / Instructions Understand the scenario on the basis of given data only. Write only SQL statements, don’t show any data. “Try to upload the assignment before BONUS day”