Question: 4. (10 points) Suppose that we have a logical schema representing movies, movie critics and their movie ratings. The relationship ratings captures which reviews were

4. (10 points) Suppose that we have a logical schema representing movies, movie critics and their movie ratings. The relationship "ratings" captures which reviews were posted by which critics with the rating (0-100) and date. The logical schema is given below: Movie: (Title, SubTitle, Year, Duration, Edition) Ratings: (RevID, Title, SubTitle, Rating, RDate) Reviewer: (ReviewerID, Name, Address, Affiliation) Create the SQL tables for above schema with all of the necessary attributes, domains, and keys. Assume that Reviewer ID is 9 characters long (fixed) string and that neither title nor sub-title needs more than 20 characters and that the rating value cannot be NULL. Date should be in date format
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
