Introduction For this assignment, you will be developing PHP/PDO code for a page or set of pages that fulfill(s) the requirements found below. Using your personal database on the MariaDB server (the one that has your zid as its name), create the tables from the SQL SELECT slides (S, SP, P) and make sure they contain the data in the rows shown in the slides (before adding the extra rows later). None of the columns should be allowed to be NULL. Data types are not specified in the tables from the slides, so feel free to choose any that would work to store the data shown. Requirements

1 There must be a way to show all of the suppliers and their details.

(10 pts) 2 There must be a way to show all of the parts and their details.

(10 pts) 3 There must be a form that allows a user to select a part and see everyone who supplies that part, along with how many of that part they have available. The information on the part chosen should be shown as well.

(20 pts) 4 There must be a form that allows a user to select a supplier and get a list of all of the parts they supply and how many of each they have. Information on the supplier chosen should also be displayed.

(15 pts) 5 There must be a way to select a part and a supplier and buy some number of parts from them, reducing the quantity they have left to supply by the amount bought. (Dont worry about tracking the purchases, just adjust the quantity appropriately.)

(15 pts) 6 There must be a form that allows a user to add a new part to the database.

(15 pts) 7 There must be a form that allows a user to add a new supplier to the database. (15 pts)

Here are the tables

SPOTY CITY 200 400 S SI S2 S3 S4 S5 SNAME STATUS Smith 20 Jones 10 Blake Clark 20 Adams 30 PPNAME COLOR WEIGHT P. Nut Red 12 T: H. Green P Screw Blue 17 P4 Screw Red 14 T'S Cam Blue 13 P6 Cey Red 19 London Paris Paris London Athens 30 SE16 SP 82 P SP2 SP SPA S4 ina 100 400 300 2001 300 400 SPOTY CITY 200 400 S SI S2 S3 S4 S5 SNAME STATUS Smith 20 Jones 10 Blake Clark 20 Adams 30 PPNAME COLOR WEIGHT P. Nut Red 12 T: H. Green P Screw Blue 17 P4 Screw Red 14 T'S Cam Blue 13 P6 Cey Red 19 London Paris Paris London Athens 30 SE16 SP 82 P SP2 SP SPA S4 ina 100 400 300 2001 300 400