Write queries in SQL for the given database schema as follows:
S(S#, SNAME, STATUS, CITY) /* Primary key S# */
P(P# PNAME, COLOR, WEIGHT, CITY) /* Primary key P# */
J(J#, JNAME, CITY) /* Primes key J# */
SPJ (S#, P#, J#, QTY) /* Primary key S#,P#J# */
S - Supplier
P- Part
J - PROJECT
SPJ - SUPPLIER-PART-PROJECT (The ternary relationship)
Queries:
a. List part Numbers for parts supplied to all projects in Paris.
b. Listproject numbers foe 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.