::: vuaskari.com ::: cs403:DBMS Solution..

1. Show all the Category names with their Supplier names.

 

Ans:SELECT category.category_name, supplier.supplier_name FROM category Inner Join supplier ON category.supplier_id = supplier.supplier_id

 

 

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

 

Ans: SELECT product.product_name, product.product_id  FROM product

 

3. Show all the products of "Bumper & Components" Category.

Ans:

 

SELECT product.product_name, category.category_name FROM product Inner Join category ON product.category_id = category.category_id WHERE category.category_name =  'Bumper & Components'

 

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

SELECT product.product_name, supplier.supplier_name FROM product Inner Join category ON product.category_id = category.category_id Inner Join supplier ON category.supplier_id = supplier.supplier_id  

 

5. Show all those Product IDs supplied by "S & S corporations".

SELECT product.product_id, supplier.supplier_name FROM product Inner Join category ON product.category_id = category.category_id Inner Join supplier ON category.supplier_id supplier.supplier_id WHERE supplier.supplier_name =  'S & S corporations'

 

 

--

Imran bashir

--
We say, "Be one as Pakistani Nation and grow up for Pakistan's Future". Wish you all the best. Join www.vuaskari.com,
To post to this group, send email to vuaskari_com@googlegroups.com
Visit these groups:
This (Main) Group:http://groups.google.com/group/vuaskari_com?hl=en?hl=en
MIT/MCS Group: http://groups.google.com/group/vu_askarimit?hl=en?hl=en
HRM Group: http://groups.google.com/group/askari_hrm?hl=en?hl=en
Banking Group: http://groups.google.com/group/askari_banking?hl=en?hl=en
Management: https://groups.google.com/group/vuaskari_mgt?hl=en
Marketing: https://groups.google.com/group/vuaskari_mkt?hl=en
MIS Group: http://groups.google.com/group/askari_mis?hl=en