Trusted by Students Everywhere
Why Choose Us?
0% AI Guarantee

Human-written only.

24/7 Support

Anytime, anywhere.

Plagiarism Free

100% Original.

Expert Tutors

Masters & PhDs.

100% Confidential

Your privacy matters.

On-Time Delivery

Never miss a deadline.

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 Nov 26, 2020

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?

Expert Solution

For detailed step-by-step solution, place custom order now.
Need this Answer?

This solution is not in the archive yet. Hire an expert to solve it for you.

Get a Quote
Secure Payment