Develop a dynamic web application as described below using PHP, MySQL, JavaScript and CSS.
Details of the weight of the assignment and due date are given in the course description.
Database Structure
The web application uses a 3-table relational database stored on a server that records the details of movie reviews. The structure of the database is:
REVIEWER(id, name, email, password)
MOVIE(id, title, release_date)
REVIEW(reviewer_id, movie_id, rating, review_date, comment, helpful)
Each record in the REVIEW table refers to one movie reviewed by one reviewer. Primary keys have been underlined.
The reviewer_id and movie_id fields form a compound primary key, and refer to the id fields in the
REVIEWER and MOVIE tables respectively.
Both date fields may be stored as either ‘YYYYMMDD' strings, or using MySQL date types. Comment should be of the TEXT datatype.
The rating field is a numeric value between 0 and 10.
The password field should be a VARCHAR field of at least 125 characters.
The helpful field is a numeric value contains a count of the number of people who have found this review useful or interesting.