VUsolutions Transferred to AchiKhasi.com
From December 2011, this blog www.VUsolutions.blogspot.com is transferred to http://achikhasi.com/vu/ . So, you may visit http://achikhasi.com/vu/ for latest study related help.
Friday, June 17, 2011
Posted In
Important Notices
Edit This
Dear Students/visitors,
We are again proudly informed you, the latest updated GURU files are NOW AVAILABLE at VUsolutions GURU.
Visit now and get download your copy and prepare your final term exams.
Remember, its VUsolutions GUARANTEE these VUsolutions' GURU files help you to get minimum 90% marks in final term exams, if you prepared well.
Best of luck you all...
VUsolutions HelpDesk..
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
| 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.
|
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 - 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” |
