This paper circulates around the core theme of The web application uses a 3-table relational database stored on a server that records the details of movie reviews together with its essential aspects. It has been reviewed and purchased by the majority of students thus, this paper is rated 4.8 out of 5 points by the students. In addition to this, the price of this paper commences from £ 99. To get this paper written from the scratch, order this assignment now. 100% confidential, 100% plagiarism-free.
Task 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.