Identify the functional dependencies between the attributes

Assignment Help Basic Computer Science

Reference no: EM13306585

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:

Movie Nbr, Title, Director ID, Director Name, Studio
ID, Studio Name, Studio Location, Studio CEO,
Character, Actor ID, Name, Movie Copy Nbr, Movie
Copy Type, Movie Rental Price, Copy Rental Status,
Copy Return Date

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):
567, "It's a Wonderful Life", 25, "Frank Capra", 234, "Liberty Films", "Hollywood, CA", "Orson
Wells", {"George Bailey", 245, "James Stewart" | "Mary Bailey", 236, "Donna Reed" | "Clarence
Oddbody", 765, "Henry Travers" | "Henry F. Potter", 325, "Lionel Barrymore" }, 5434, "DVD",
2.95, "Rented", "12/15/2010"

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.

Reference no: EM13306585

Questions Cloud

Compute the density of the object : The density of a pail of water is 10.0g/cm. An object has sunk to the bottom of the pail. What is the density of the object

Determine the delays of the carry out : Determine the delays of the carry out bit c48 and the gate complexity, i.e, the numbers of AND, OR and XOR gates needed for implementing the following 48-bit adders.

List all the possible techniques that you might use : Elmwood College Situation: The school is considering a new system that will speed up the registration process. As a systems analyst, you are asked to develop a plan for fact-finding.

What will be the stars rotation period : A uniform, spherical cloud of interstellar gas has mass 2.0Ã-1030 kg and radius 9.0Ã-1012 m, what will be the star's rotation period

Identify the functional dependencies between the attributes : Present the attributes organized into 3NF relations that have been named appropriately.

What are some possible problems that could still exist : A user complains to you that her system hangs for no known reason. After asking her a few questions, you do identify these symptoms: The system hangs after about 15-20 minutes of operation.

What are some of the symptoms of a failing processor : What are some of the symptoms of a failing processor? What are some approaches that could be taken to ensure that it is for certain that the processor is failing?

Find the forces in the members of thc truss : Find the forces in the members of thc truss shown using the method of joints and determine the forces in all the members of the truss shown using the methods of joints.

Perform the arithmetic encoding and decoding : Perform the arithmetic encoding and decoding of the following message ABBCAB$.

User Account

All Pages