Question

ER Diagram for movies:

1. Each movie is uniquely defined by it's "title", "year of release" and "country that released it".

2. Each movie has a "duration".

3. Each movie has a "rating" which may be different in different countries.

4. Each movie has a "director".

5. Each movie has at least one writer which may have different roles (ex. script writer or book author).

6. Each movie has at least one genre.

7. Each movie has some actors and each actor has at least one role.

8. Each movie has some "behind the scene agents" and each one of them has at least one job title.

9. Each movie can have a "release date" (day/month/year) in different countries.

10. Each movie & actor can be nominated for different awards. (awards have title, year, role)

11. Each movie & actor may win an award. (awards have title, year, role)

12. Each actor is uniquely defined by his/her name.

13. Each actor has "date of birth", "place of birth", "biography".

14. Each actor can have a "alias".

15. Each lasting dialog, is a sequence of sentences told by story roles. (can be individual or multidaceted roles)

I'm mostly stuck at 3, 9 and 15.

Thank you in advance.

Answer 1

In 3 and 9, their will be another entity, with attributes: (country, rating, releasedate, title) where "country" as foreign key referrence to "country that released it" from table movie and "title" as foreign key reference to "title" from table title.

In 15, To me, lasting dialogs are a bunch of sentences said by each actor in a movie. So adding an entity between movie and actor allow you to include that data, just add the field "order" to define the order of the sentences and a title to differentiate between dialogs. Movies can have many dialogs, each dialogs have many sentences, each sentence is said by one Actor.