3. The schema depicted in Question 2 showed a many-to-many relationship between actors and movies. However,...

Transcribed Image Text:

3. The schema depicted in Question 2 showed a many-to-many relationship between actors and movies. However, this is not directly implementable in a relational database, so we introduce a new entity, APPEARANCE, in which each row represents an appearance of an actor a movie type of entity a. What kind of entity is APPEARANCE? Appearance is a b. What is the connectivity of the relationship between ACTOR and APPEARANCE? Many to many c. What is the connectivity of the relationship between MOVIE and APPEARANCE? d. Draw a diagram showing the updated schema, with all four entities. Show all needed attributes of the APPEARANCE entity. (You may omit other entities' attributes.) e. List the foreign key(s) in the APPEARANCE table. f. What is the primary key in the APPEARANCE table? SC150 2. Consider the following schema for a database of movies: VIE_ID STUDIO STUDIO ID STUDIO NAME produces Midterm Exam PK Barbie Oppenheimer Barbie MOVIE MOVIE ID MOVIETITLE STUDIO ID +4 STUDIO_NAME STUDIO ID 29 Warner Bros. 25 Universal 29 Warner Bros. 101 ACTOR 108 ACTOR JO a. State the four business rules that specify the connectivities of the relationships among these entities. 112 b. Consider a bad database design has the following table in it: MOVIE_TITLE ACTOR_ID ACTOR LNAME Robbie Fall 2023 ACTOR NAME ACTOR FNAME appears in Murphy Gosling ACTOR FNAME Margot Cillian Ryan Briefly describe a hypothetical situation in which you might encounter an anomaly in making a change to this database, and name the type of anomaly. 3. The schema depicted in Question 2 showed a many-to-many relationship between actors and movies. However, this is not directly implementable in a relational database, so we introduce a new entity, APPEARANCE, in which each row represents an appearance of an actor a movie type of entity a. What kind of entity is APPEARANCE? Appearance is a b. What is the connectivity of the relationship between ACTOR and APPEARANCE? Many to many c. What is the connectivity of the relationship between MOVIE and APPEARANCE? d. Draw a diagram showing the updated schema, with all four entities. Show all needed attributes of the APPEARANCE entity. (You may omit other entities' attributes.) e. List the foreign key(s) in the APPEARANCE table. f. What is the primary key in the APPEARANCE table? SC150 2. Consider the following schema for a database of movies: VIE_ID STUDIO STUDIO ID STUDIO NAME produces Midterm Exam PK Barbie Oppenheimer Barbie MOVIE MOVIE ID MOVIETITLE STUDIO ID +4 STUDIO_NAME STUDIO ID 29 Warner Bros. 25 Universal 29 Warner Bros. 101 ACTOR 108 ACTOR JO a. State the four business rules that specify the connectivities of the relationships among these entities. 112 b. Consider a bad database design has the following table in it: MOVIE_TITLE ACTOR_ID ACTOR LNAME Robbie Fall 2023 ACTOR NAME ACTOR FNAME appears in Murphy Gosling ACTOR FNAME Margot Cillian Ryan Briefly describe a hypothetical situation in which you might encounter an anomaly in making a change to this database, and name the type of anomaly.

Answer rating: 100% (QA)

The questions on the exam paper pertain to database design and the resolution of manytomany relationships between entities using an associative entity ... View the full answer