Consider a database that has the following tables, named MOVIE, ACTOR, and STUDIO. Assume each table's...

Transcribed Image Text:

Consider a database that has the following tables, named MOVIE, ACTOR, and STUDIO. Assume each table's first column is its primary key, and there is no data other than what is shown here. ACTOR LNAME ACTOR FNAME MOVIE ID 4000 4001 4000 MOVIE TITLE Barbie Oppenheimer Super Mario Bros. STUDIO ID 29 25 STUDIO ID 29 25 36 ACTOR_ID 101 108 112 Robbie Murphy Gosling Pratt Margot Cillian Ryan Chris STUDIO_NAME Warner Bros. Universal a. For each table, state whether it satisfies or violates entity integrity, and explain why. . State whether the MOVIE table satisfies or violates referential integrity, and explain why. Consider a database that has the following tables, named MOVIE, ACTOR, and STUDIO. Assume each table's first column is its primary key, and there is no data other than what is shown here. ACTOR LNAME ACTOR FNAME MOVIE ID 4000 4001 4000 MOVIE TITLE Barbie Oppenheimer Super Mario Bros. STUDIO ID 29 25 STUDIO ID 29 25 36 ACTOR_ID 101 108 112 Robbie Murphy Gosling Pratt Margot Cillian Ryan Chris STUDIO_NAME Warner Bros. Universal a. For each table, state whether it satisfies or violates entity integrity, and explain why. . State whether the MOVIE table satisfies or violates referential integrity, and explain why.