Grocery Website

What to do:

Create a Web application that will allow you to view the records, add a single record, delete a single record, update a single record from a one-table database. Your application must include the following:

MySQL database hosted on AWS RDS: (Note, you must use the names described here) Create a single table database with the name grocery. This database will include one table called products. The structure of your table is described in the following table. Be sure to use the field names as shown in the table.

Read Use Case: When the application loads, an updated view of the table values should be displayed on the page. Your application should return to this view after any of the remaining use cases are completed. Be sure to include appropriate links and/or form elements to launch the other use cases.

Add Use Case: When a user wants to add a record, they should be able to view a form to enter the new record data. Once the form is completed, the data should be entered as a new record into the products table and the view return to the Read Use Case view. The new record should appear in the updated Read.

Delete Use Case: The user should be able to click on a link related to a particular record to delete the record. Once the record is deleted, the user should be presented with the updated Read view.

Update Use Case: The user should be able to click on a link related to a particular record to update the record. They should then be presented with a pre-filled form that includes the current data from the record. The user can then change only those fields that are needed and then click something to update the record. Once the record is updated, the user should be presented with the updated Read view.

Additional Requirements:

Your application should conform to the following requirements:

• Each use case must be completed using the MVC design pattern.
• The database table must be created exactly as described above (including the names provided).
• Use CSS to create a pleasing, consistent view for each page. Hint: The primary key for this database is treated differently then the primary key of the example, Sci Fi Library database. This will require a slight change to how you write your Add query.