Solve Ex 4.1

4.1 Fig. 4.5 shows some sample data values for an extended form of the suppliers-and base called the suppliers-parts-projects database. Suppliers (S), parts (P), and projects uniquely identified by supplier number (S#) part number (P#) and project number ( tively. The predicate for SPJ (shipments) is: Supplier S# supplies part P# to project in on (the combination {SAMI#Jis the primary key, as the figure indicates) Write an app set of SQL definitions for this database. Note: This database will be used as the basis for exercises in subsequent chapters -parts d J#), respe S | S# | SNAME | STATUS | CITY S1 Smith S2 Jones S3 Blake S4 Clark S5 Adams 20 London 10 Paris 30 Paris 20 London 30 Athens S1 P1 J1 200 S1 Pl J4 700 S2 P3 J1 400 S2 P3 J2 200 S2 P3 J3 200 S2 P3 J4 500 S2 P3 J5600 S2 P3 J6400 S2P3 J7800 S2 P5 J2100 S3 P3 J1200 S3 P4 J2500 S4 P6 J3300 S4 P6 J7300 S5 P2 J2200 S5 P2 J4 100 S5 P5 J5500 S5P5 J7 100 S5 P6 J2 200 S5 P1 J4100 S5 P3 J4200 S5 P4 J4800 S5 P5 J4 400 S5 P6 J4 500 P | P# | PNAME | COLOR | WEIGHT | CITY Red Green Pl Nut P2 Bolt Gr P3 ScrewBlue P4 Screw Red P5 Cam P6 Cog 12.0 London 17.0Paris 17.0 Oslo 14.0 London 12.0 Paris 19.0 London Blue Red CITY J1 Sorter Paris J2Display Rome Athens J4 Console Athens J5 RAID J6EDS J7Tape London Oslo Londorn Fig. 4. The suppliers-parts-projects database (sample values) 5