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.