1 Construct the physical design Diagram for the following: Let database "supply-part-project" have 4 tables (s, P, J, SPJ): S = SID * SNAME * STATUS * CITY; PPID PNAMECOLORWEIGHTCITY (Products) JJID JNAME CITY; SPJ = ID * SID * PID * JID * QTY. (suppliers) (Projects) It means you buy products from a supplier for a project. Example: SID SNAME STATUS 10 0 CITY New York S001 Kmart PID P0001 PNAME Bolt COLOR Green WEIGHT 12 CITY Paris (60 points) Inner Join (1) Get products supplied by a London supplier to a Paris project. (2) Get ALL colors of parts supplied by Atlanta supplier to Savannah project. (3) Get product ID's supplied to any project. (4) Get the number of supplier in each city who has supplied Paris project