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.

Back to home VUsolutions

VUsolutions Fans Club [join us for MORE solutions]

VUsolutions on Facebook

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

Friday, June 17, 2011 Posted In 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.
 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”

Back to home VUsolutions

Shaadi.com: Just create ur account & find ur partner or EARN money, its reall & EASY

VUsolutions Followers (Join NOW and Get Extra Benefits)

Install LATEST toolbar having lot of features - GET solutions on Desktop

toolbar powered by Conduit
Caliplus 300x250 NoFlam VitoLiv 468x60 GlucoLo