Homework answers / question archive / An online movie database keeps tracks of information on movies, actors, directors, the genre of movies, and the characters portrayed by each actor in the movie

An online movie database keeps tracks of information on movies, actors, directors, the genre of movies, and the characters portrayed by each actor in the movie

Computer Science

Share With

An online movie database keeps tracks of information on movies, actors, directors, the genre of movies, and the characters portrayed by each actor in the movie. The specific data requirements for the database is summarized as follows: Each movie is identified by a unique number. Other information kept on each movie is the name of the movie, length of the movie, release date and parental rating.


An actor is identified by a unique number, first name, last name, date of birth and gender.
A director is identified by a unique number, first name, last name, date of birth and gender.
A character is identified by a unique number, first name, and last name.
A genre is identified by a unique number and the description of the genre.
A Movie has multiple actors (or none at all).
An Actor can play multiple roles in a movie.
A character must be associated with a movie and an actor.
A character can be in multiple movies. (i.e. Sequels)
A character can be portrayed by multiple actors in a movie. (i.e. Character in a movie has a younger and older version - two actors need to play the part).
A Movie can have multiple directors (or none at all).
A movie must have at least one genre (or could have many).


What is the proper DBDL in 3NF?