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
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
Need this Answer?
This solution is not in the archive yet. Hire an expert to solve it for you.





