Questions 36 through 39 relate to the following relational s…
Questions 36 through 39 relate to the following relational schema. This relational schema is used to build a relational database to keep track of movies and their box office revenues in different countries. The domain definitions for the attributes of the relations are given in the following table. Attribute Description Data Type MovieID Unique identifier of the movie Numeric: size 10 MovieName Official title of the movie Variable Character: size 50 YearReleased 4-digit number corresponding the year in which the movie is released Numeric: size 4 SequelID MovieID of the movie to which the movie in the record is sequel Numeric: size 10 Country Country Name (e.g., USA, Canada) Variable Character: size 20 BoxOffice Total dollar amount that the movie made in the country’s movie theaters Numeric: size 12 To help you visualize the structure of the database, a few rows from each table are shown below for illustration purposes. Performance_T MovieID Country BoxOffice 1110000001 Germany 25,560,500 1110000001 USA 267,652,800 1110000001 Italy 15,030,300 1110000001 Turkey 10,340,500 2220000001 USA 1,200,000 3330000001 Italy 1,300,000 … … …. Movie_T MovieID MovieName YearReleased SequelID 1110000002 Shrek 2 2004 1110000001 1110000001 Shrek 2001 2220000001 The Usual Suspects 1995 3330000001 Kingdom of Heaven 2005 4440000001 Superman 1978 4440000002 Superman 2 1980 4440000001 … … … … When a record for a movie is deleted in Movie_T, all related records in Performance_T are also deleted by the DBMS automatically. Which of the following clauses must have been included in the foreign key constraint and in which table definition?