Mysql | Computer Science homework help

1. use MySQL to create a database of information about used trucks for sale, similar to the cars database used in this chapter. Make up equipment that characterizes trucks. Get the raw data from the ad section of your local newspaper. Instead of using the states in the cars database, divide your town into four sections and use them.

2. Modify and test the program access_cars.php to handle UPDATE and INSERT SQL commands, as well as SELECT.
3. In a separate copy of the preceding work, add a textbox that doesn’t read a SQL statement but text that your database will look for the truck type into the textbox. Following will be links to the data with which you will work.