Given the following schema and the supporting information complete the questions that follow:
Movies(Title, Year, filmType, DirectedBy)
Stars(Title, Year, StarName, Salary)
Oscars(Title, Year, OscarAwardType, AwardedTo)
BoxOffice(Title, Year, City, GrossSales)
Ratings(Title, Year, Reviewer, Score)
The Movies relation contains the list of all movies. The value of the filmType attribute may be 'horror', 'romance', 'thriller' etc. (Title, Year) form a key in the Movies relation. The Salary attribute in the Stars relation is the amount paid to StarName for working in the movie: (Title, Year). The Oscars relation has a tuple for each Oscar awarded to a movie. The only awards of interest to us are the Best Actor, Best Actress, and Best Director awards. A typical record in the Oscars relation would look like
(Cleopatra, 1963, Best Actor, Rex Harrison).
The BoxOffice relation records for each movie its gross sales at the box office for each city. Also, each movie is rated at a scale of 1-10 by many reviewers. The rating information is kept in the relation Ratings.
1. Write SQL statements to create the above tables using SQL DDL statements.
2. Write an INSERT statement to add two new records to each table.