Question
Entity relationship diagram and relational model Each agent represents up to 10 actors but each actor has only one agent Actors take parts in the
Entity relationship diagram and relational model
Each agent represents up to 10 actors but each actor has only one agent Actors take parts in the movies. Every movie production employs many actors and every actor can play in various movies Movie studios produce multiple movies. A movie can be produced only by one studio. Before shooting begins, the dates when the actor's role is shot (start and end) are decided, so that they dont overlap with dates of other movie shoots the actor is also taking part in. This is the agent's job to keep track of this. The agency needs a database to maintain the following data for its actors and agents: 1. Actor: name, address, phone, age, acting style. 2. Movie: title, genre, director, producer, studio. 3. Movie studio: name, address, phone. 4. Actor's schedules: name of actor, name of movie, start and end date of the shoot. 5. Agent: name, address, phone. Answer the following Design an entity relationship model for the agency database. Produce an ERD diagram using UML notation. Display entities, attributes, identifiers and cardinality. Dont use surrogate keys. Then convert this entity relational model to a relational model.
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