LABSHEET 6 � querying multiple tables

Document Sample
LABSHEET 6 � querying multiple tables Powered By Docstoc
					LABSHEET 6 – querying multiple tables


Objective:
   To become familiar with queries across multiple tables.

As we have made different modifications on tables in Lab5, therefore, no standard answers are provided in this lab
sheet.


Queries:
Create queries for the following (don’t forget to take a look at the SQL Access produces):

    1) Find the name and status of all suppliers who supply part P4.

    2) Find the name, colour and weight of each part which is supplied to project J2.

    3) Find the name, colour and weight of each part not supplied to project J2.

    4) Find the name of each supplier and the name of each part where the supplier supplies the
       part to project J4.

    5) Find the name and status of each supplier and the name and weight of each part where the
       supplier supplies the part to the RAID project.

    6) List the name of each project along with a total of all the parts supplied to that project.

    7) List the name of each project along with the name of each supplier who has supplied parts to
       that project and the total parts supplied by that supplier to that project.

    8) List each supplier along with a list of the colours of the parts that supplier has supplied.


    Optional:

    9) Produce a report showing a table of all the suppliers and the aggregated total number of
       parts each supplier has supplied to the various projects; also display this information as a bar
       chart.

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:0
posted:9/29/2012
language:Unknown
pages:1