Question: 4 5 6 7 8 9 1 0 1 1 1 2 1 3 1 4 1 5 1 6 1 7 1 8 1

4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
Review
The Movie table has the following columns:
IDinteger, primary key
Titlevariable-length string
Genrevariable-length string
RatingCodevariable-length string
Yearinteger
The YearStats table has the following columns:
Yearinteger
TotalGrossbigint unsigned
Releasesinteger
Write a SQL statement to designate the Year column in the Movie table as a foreign key to the Year column in the YearStats table.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!