For the following database schema:

Write queries that:

a) List part numbers for parts supplied to all projects in Paris.

b) List project numbers for projects supplied with at least all the parts available from supplier S1

c) List project numbers for projects supplied entirely by supplier S1

d) List supplier that only supplies the parts to the projects located in Paris

S (S#, SNAME, STATUS, CITY) - Primary key: S#

P (P#, PNAME, COLOR, WEIGHT, CITY) - Primary key P#

J (J#, JNAME, CITY) - Primary key J#

SPJ (S#, P#, J#, QTY) - Primary key S#,P#,J#

ADDITIONAL INFO:

S Supplier

P- Part

J - PROJECT

SPJ SUPPLIER-PART-PROJECT (The ternary relationship)