I am designing a database for the Film industry (personal exercise).
- Each film was made by a company.
- A company produces one or more movies.
- Each film has one or more genres (action, terror, etc ...)
- Each film has one or more actors.
- Each film is directed by one or more directors (it is possible that a director act in a movie, including the one he is directing.)
- Each movie has zero or more phrases spoken by an actor.
- Each actor has a role in the film.
I still can not correctly identify the
Dependencias Funcionales and the
Dependencias Transitivas .
- EDITED -
I've been doing this until now ...
Diagram in SQL Server:
My questions are:
I am very confused, I hope you can help me, thanks in advance.