In: Computer Science
Database:
Our AD is Movie Theater.
Create an ER diagram with the following entities: Staff, Ticket,
Movie, Session, Hall, Seat, Director, Actor, Distributor, and
Roles. AND also identify the type of relations
between the entities with notations and explain why you used
it.
**Read the question carefully before you answer**
The entity staff is related to ticket by
issuing a ticket for a session. Here ticket is weak entity as it
has no existence without a staff or session so, ticket is mentioned
as double rectangle.
One staff can isssue many tickets denoted as one to many relationship. One ticket is essential for a particular session so they both has one to one relationship.
Session is entity with two derived entities movie playing in each session and related Hall. So it is denoted as has a relationship.
Hall has seats as weak entity. Entity movie is related to actor distributor and director.
Movie is directed by a director and both has one to one relationship as one director directs one movie.
Movie is distributed byba distributor both of them also have one to one relationship.
Movie is performed by an actor and it has one to one relationship. And the entity has a weak entity as roles as roles can't exist without an actor.