We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>

Looking For Something at vustudents.ning.com? Click Here to Search

www.bit.ly/vucodes

+ Link For Assignments, GDBs & Online Quizzes Solution

www.bit.ly/papersvu

+ Link For Past Papers, Solved MCQs, Short Notes & More

 

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

 

GOOD LUCK

 

 

 

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.

 

 

  1. Show all the names of Products with their IDs.

 

 

  1. Show all the products of “Bumper & Components” Category.

 

 

  1. Show all the Product names and their Supplier names.

 

 

  1. 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”

 

 

 

 

 

+ Click Here To Join also Our facebook study Group.

+ How to Join Subject Study Groups & Get Helping Material?

+ How to become Top Reputation, Angels, Intellectual, Featured Members & Moderators?


See Your Saved Posts Timeline

Views: 196

.

+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

+ Click Here to Search (Looking For something at vustudents.ning.com?)

Replies to This Discussion

As salam o alikum allllllls

Solution cs403 4th assign

Remind me in your prayers

Thanks           

Attachments:
Text file
Attachments:

CS403 Database Management Systems Assignment#04 Solution

See the attached file please

Attachments:
Thank yu sooo

RSS

Latest Activity

M +S +K posted a status
"Tum Aik Shayar Ki Mohabbat Ho Jaana, Zinda Rahogi Hemesha Lafzon Mein"
6 minutes ago
M +S +K posted a status
"Kabhi Parh Toh Sahee Meri Aankhon ko, Yahan Samundar Behta Hai Teri Mohabbat Ka"
7 minutes ago
Zain Kazimi posted discussions
8 minutes ago
Zain Kazimi liked Zain Kazimi's discussion Self Poetry
9 minutes ago
M +S +K posted a status
"Usne Apni Aankhon Se Tableegh Hee Yun Ki, Main Bina Soche Mohabbat Pe Iman Le Aaya"
10 minutes ago
M +S +K posted a status
"Mohabbat Azmani Ho Toh Bus Itna Hee Kaafi Hai, Zara Sa Ruth Kar Dekho Manane Kaun Aata Hai"
11 minutes ago
M +S +K posted a status
"Yeh Ishq, Mohabbat, Pyaar Nahi Maloom Kya Hai, Per Humein Jo Tumse Hai Woh In Sab Se Bhi Judaa Hai"
13 minutes ago
M +S +K posted a status
"Mohabbat Toh Bahut Soh’n Se Milegi, Tumhe Yaad Aayeinge Aadab Mere"
15 minutes ago

© 2019   Created by + M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service