Problem

The following attributes represent data about a movie copy at a video rental store. Each...

The following attributes represent data about a movie copy at a video rental store. Each movie is identified by a movie number and has a title and information about the director and the studio that produced the movie. Each movie has one or several characters, and there is exactly one actor playing the role of each of the characters (but one actor can play multiple roles in each of the movies). A video store has multiple copies of the same movie, and the store differentiates copies with a movie copy number, which is unique within a single movie but not unique between different movies. Each movie copy has a rental status and return date; in addition, each copy has a type (VHS, DVD, or Bluray). The rental price depends on the movie and the copy type, but the price is the same for all copies of the same type. The attributes are as follows:

A sample data set regarding a movie would be as follows (the data in the curly brackets are character/actor data, in this case for four different characters):

Based on this information,

a. Identify the functional dependencies between the attributes.

b. Identify the reasons why this set of data items is not in 3NF and tell what normal form (if any) it is in.

c. Present the attributes organized into 3NF relations that have been named appropriately.

Step-by-Step Solution

Request Professional Solution

Request Solution!

We need at least 10 more requests to produce the solution.

0 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)


All students who have requested the solution will be notified once they are available.
Add your Solution
Textbook Solutions and Answers Search