06-14-2011, 04:06 AM
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:
o The assignment is submitted after due date.
o The submitted assignment does not open or file corrupt.
o The submitted assignment is in the format other than MS Word (doc).
o The assignment is copied (from other student or copy from handouts).
o Student ID is not mentioned in the assignment File or name of file is other than student ID.
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”
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:
o The assignment is submitted after due date.
o The submitted assignment does not open or file corrupt.
o The submitted assignment is in the format other than MS Word (doc).
o The assignment is copied (from other student or copy from handouts).
o Student ID is not mentioned in the assignment File or name of file is other than student ID.
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”
0300-9520262
Get solution in 24 hour |cpmputer & internet
mileys81:[SIZE="4"][SIZE="3"]....[/SIZE][/SIZE]