LABSHEET 6 – querying multiple tables
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
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.
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