CS403 Assignment No. 4 (June 2011) - solution soon
Friday, June 17, 2011 Posted In CS and IT Edit This
Assignment No. 04
Semester Spring2011
Database Management Systems-CS403
Total Marks: 15
Due Date: 20/06/2011
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:
|
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)
- Show all the Category names with their Supplier names.
- Show all the names of Products with their IDs.
- Show all the products of “Bumper & Components” Category.
- Show all the Product names and their Supplier names.
- 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
“Try to upload the assignment before BONUS day” |
