UML Relationship Diagramm von Supplier-Part-Projekt-Datenbank

Aufgabe 6)
1)
select spp.sppnr
FROM spp spp
WHERE spp.quantity BETWEEN 100 AND 350;

2)
SELECT pt.partnr, pt.name
FROM part pt, spp spp, project pj
WHERE pt.partid=spp.partid
AND pj.projectid=spp.projectid
AND pj.city='Nuremberg';


3)
SELECT pj.projectnr
FROM part pt, spp spp, project pj, supplier sp
WHERE spp.projectid=pj.projectid
AND spp.partid=pt.partid
AND spp.supplierid=sp.supplierid
AND pt.color='red'
AND sp.name='S1';

5)
SELECT pt.partnr, SUM(spp.quantity) as total
FROM part pt, spp spp
WHERE pt.partid=spp.partid
GROUP BY pt.partnr;