The items and their reviews, are stored in the MariaDB database as developed for Lab 5. You may make minor changes to the database tables, e.g. add or remove a column, rename a column, or change the data type of a column. You may also add tables.
computer science
Description
Requirements
Your site should meet the following minimum requirements:
● The application applies the MVC pattern.
● The items and their reviews, are stored in the MariaDB database as developed for Lab 5. You may make minor changes to the database tables, e.g. add or remove a column, rename a column, or change the data type of a column. You may also add tables.
● The web application accesses the database through the username reviewer and password review2020 .
● The site consists of at least three pages:
○ A homepage which displays the three items with the highest reviews that have been most recently submitted through the web browser displaying the home page. Use cookies and/or the session array to track the three most recently reviewed items.
○ A page that displays all items. An item can be selected to view all details about the item and to view its review. The reviews may be displayed on the same page as the selected item or on a new page for the selected item. ○ One or more pages that allow the user to submit, edit, or delete a review for an item.
● Each page must include the navigation menu.
● All pages are professionally styled.
○ Note that the focus on this project is the functionality of the web application. Thus keep
the styling simple.
○ Best practices for HTML5 and CSS are applied.
Include the updated SQL script file from Lab 5. Populate all tables with data through insert
statements in the SQL script. As in Lab 5, there has to be at least one item without any reviews,
one item with a single review, and one item with multiple reviews. Make sure the user reviewer
is granted the appropriate access rights in the SQL script.
