The local farmers are having problems with some pesky crows eating their crops. As a counter-measure, they have decided to concoct some pretty scary scarecrows; in fact, most of the farmers will be constructing multiple scarecrows for their fields. To make one scarecrow, they need one pumpkin for the head, some nuts for the eyes and mouth, and a carrot for the nose. At the local Farmers Market everyone is selling Halloween items, but the farmers all stop at Farmer Freds stand because he is selling everything that they need.

Because of the increased demand for pumpkins, nuts, and carrots, Farmer Fred has asked for your help. He needs a way of displaying an up-to-date record of all the pumpkins, nuts and carrots he has in stock. Your job is to create a web-based mini-application to do this, as follows: (Write your mysql command for each of the following questions respectively and number them clearly.)

Create a new database with the name: FredBiz

Using a single command, create a new user named Fred with a password of Farmer#Fred. He should have full access to the FredBiz database but no other. You should use Farmer Freds account to access the database in your web application

As user Fred (dont forget to reinitialize the log file), login to mysql and create a table in FredBiz named Halloween with the following columns:

o id (INTEGER)

o qty (INTEGER)

o description (VARCHAR(20))

o weight (INTEGER)

* Enter the following records into the Halloween table:

id qty description weight

1 20 pumpkin 10

2 43 mixed nuts 2

3 25 pumpkin 15

4 87 bag carrots 1

5 9 pumpkin 20

6 52 mixed nuts 1

7 68 bag carrots 2

8 5 pumpkin 25

As user Fred, login to mysql and create a table in FredBiz named users with the following columns:

o id (INTEGER)

o username (VARCHAR(20))

o password (VARCHAR(16))

* Enter the following records into the Halloween table:

Write a login page that will enable the user to register. For returning users such as "batman" or "jdoe", once they enter the correct username and password information they will go to the next page to specify what he/she is looking for. Please note that this next page and all the following pages should contain the username information as long as he/she is in the session.

Write an input form that will ask the user for the item he/she is looking for. Use a heading at the top that says Freds Market Biz and a smaller subheading that says Current Inventory.

The form should contain a text input control to enter a description of the desired item. You may use a select input control or radio buttons to choose the desired item if you prefer.

Write the corresponding target script of Freds MarketBiz Current Inventory page. The target script should contain the same heading at the top and have the same overall look and feel as the previous page with the input form. As a subheading, this page should display the name of the item the application was looking for, followed by a nicely-formatted table that contains a list of ids, qtys and weights of all matching items. The table headers should clearly state the information in the columns, specifying that the weight is in pounds (lbs).

Dont forget to account for the possibility that there are no records for that item. Somewhere on the target page, put a link or a button to allow Fred to return to the original page with the input form easily.

The application should also be able to let the user who is in the system to enter new information to the Halloween table and to delete old information from it. Add additional buttons or links if needed.

Once the user finishes with the pages, he/she should be able to log out from the application.

Create a CSS file (external) to have the same visual effect on the web application.

Generate the MYSQL dump file for the database and its content.

Make sure to send in only one zipped file which contains

* All php, html, css, js, MYSQL dump file, and other source files necessary to implement fully the web interface.

* A text file containing any notes I will need to get started, like usernames/passwords and where to begin