Question
A movie may have many actors, and an actor can act in many movies. A movie may have many animators working on it, and an
A movie may have many actors, and an actor can act in many movies.
A movie may have many animators working on it, and an animator may work on many different movies.
Suppose we try to represent this in our database using a single "Credits" table, with columns movie_id, actor_id and animator_id.
The key of the table is the combination of all 3 attributes.
The attributes are each foreign keys to tables for Movies, Actors and Animators, respectively. What is wrong with this?
A movie may have many actors, and an actor can act in many movies.
A movie may have many animators working on it, and an animator may work on many different movies.
Suppose we try to represent this in our database using a single "Credits" table, with columns movie_id, actor_id and animator_id.
The key of the table is the combination of all 3 attributes.
The attributes are each foreign keys to tables for Movies, Actors and Animators, respectively. What is wrong with this?
a, An actor may play more than one role in the same movie
b. The table would be too big
c. Not all movies have actors
d. Either the actor_id or animator_id field would be null
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Modern Database Management
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
13th Edition Global Edition
1292263350, 978-1292263359
