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?..


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

Please Discuss here about this assignment.Thanks

Attachments:

tariq bhai koi idea to dain k is assi main karna kia ha dear....aaj last date hay..... 

 

sir plz upload some idea solution.
any body upload the idea solution of this assignment please
sir plz upload solution......
See the attached file for CS403 Assignment Solution Spring 2011
Attachments:

 

IDEA SOLUTION (cs403)

4th Assignment 

 

Create table product (product_id varchar(10), product_name varchar(20) , category_id varchar(20) )

Create table category(category_id varchar(10), category_name varchar(20) , supplier_id varchar(20) )

Create table supplier(supplier_id varchar(10), supplier_name varchar(20) )

INSERT INTO `category` (`category_id`, `category_name`, `supplier_id`) VALUES

('CT-1', 'Bumper & Components', 'SP-1'),

('CT-2', 'Fenders & Components', 'SP-2'),

('CT-3', 'Mirrors & Components', 'SP-2'),

('CT-4', 'Hoods & Components', 'SP-3');

INSERT INTO `product` (`product_id`, `product_name`, `category_id`) VALUES

('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');

INSERT INTO `product` (`product_id`, `product_name`, `category_id`) VALUES

('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');

Above steps are not Required as part of assignment Its just for you to create and populate the table data to verify the commands

Show all the Category names with their Supplier names.

SELECT Category_Name, Supplier_Name
FROM Category, Supplier
WHERE category.supplier_id = supplier.supplier_id;

 

Show all the names of Products with their IDs. 

SELECT Product_Name, Product_ID
FROM Product;

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

SELECT product_name
FROM product, category
WHERE product.category_id = category.category_id
AND category_name = "Bumper & Components"



Show all the Product names and their Supplier names.

SELECT product_name, supplier_name
FROM product, category, supplier
WHERE product.category_id = category.category_id
AND category.supplier_id = supplier.supplier_id

 

Show all those Product IDs supplied by “S & S corporations”.

SELECT product_ID, supplier_name
FROM product, category, supplier
WHERE product.category_id = category.category_id
AND category.supplier_id = supplier.supplier_id
AND supplier_name = "S & S corporations"


IDEA SOLUTION
IDEA SOLUTION (cs403)

4th Assignment 



Create table product (product_id varchar(10), product_name varchar(20) , category_id varchar(20) )

Create table category(category_id varchar(10), category_name varchar(20) , supplier_id varchar(20) )

Create table supplier(supplier_id varchar(10), supplier_name varchar(20) )

INSERT INTO `category` (`category_id`, `category_name`, `supplier_id`) VALUES

('CT-1', 'Bumper & Components', 'SP-1'),

('CT-2', 'Fenders & Components', 'SP-2'),

('CT-3', 'Mirrors & Components', 'SP-2'),

('CT-4', 'Hoods & Components', 'SP-3');

INSERT INTO `product` (`product_id`, `product_name`, `category_id`) VALUES

('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');

INSERT INTO `product` (`product_id`, `product_name`, `category_id`) VALUES

('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');

Above steps are not Required as part of assignment Its just for you to create and populate the table data to verify the commands

Show all the Category names with their Supplier names.

SELECT Category_Name, Supplier_Name
FROM Category, Supplier
WHERE category.supplier_id = supplier.supplier_id;



Show all the names of Products with their IDs. 

SELECT Product_Name, Product_ID
FROM Product;

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

SELECT product_name
FROM product, category
WHERE product.category_id = category.category_id
AND category_name = "Bumper & Components"




Show all the Product names and their Supplier names.

SELECT product_name, supplier_name
FROM product, category, supplier
WHERE product.category_id = category.category_id
AND category.supplier_id = supplier.supplier_id



Show all those Product IDs supplied by “S & S corporations”.

SELECT product_ID, supplier_name
FROM product, category, supplier
WHERE product.category_id = category.category_id
AND category.supplier_id = supplier.supplier_id
AND supplier_name = "S & S corporations"
can someone tell us what should we put as a part of assignment. We are confused
thanks a lot for this kindness

As salam o alikum alllllllllls

Kiran sis we make quaries to search the required results

plz upload solution today is expire day plzzzzzzzzzzzzzzzzzzzzzzzzz

RSS

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

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