Question: 2) What normal form is this data in? Why? 3) What is the primary key of this table? 4) Draw a functional dependency diagram for

2) What normal form is this data in? Why? 3) What is the primary key of this table? 4) Draw a functional dependency diagram for this table 5) From your functional dependency diagram, determine the maximum set of 3NF tables that could be generated to minimize the data in the original table the most. Include tabulations (i.e., show the data) for your tables. Underline the primary key of each table. Circle or highlight the total number of tables you developed.

Date out

Last Name

First name

Zip code

Title

Video ID

Shipment ID

City

State

Total rental fee

Whole sale cost

Rental ID

Movie ID

Dist. ID

Cust. Acct.

No

7/23/2000

Smith

John

20783

Titanic

V127

S076

Adelphi

MD

$3.00

$120.00

R100

M012

D006

C074

7/23/2000

Smith

John

20783

Bambi

V099

S076

Adelphi

MD

$1.25

$100.00

R101

M177

D006

C074

7/23/2000

Jones

John

21113

Top Gun

V006

S055

Odenton

MD

$0.99

$110.00

R102

M050

D003

C049

7/23/2000

Smith

Bill

20783

Titanic

V128

S075

Adelphi

MD

$3.00

$125.00

R103

M012

D004

C202

7/23/2000

Jones

Bill

21114

Scream

V299

S050

Crofton

MD

$2.75

$109.00

R104

M180

D006

C210

7/24/2000

Jones

Jill

20783

Scream

V300

S049

Adelphi

MD

$2.55

$110.00

R105

M180

D005

C211

7/24/2000

Jones

John

21113

Scream

V301

S049

Odenton

MD

$2.55

$110.00

R106

M180

D005

C049

7/24/2000

Smith

John

20783

Top Gun

V006

S055

Adelphi

MD

$0.99

$110.00

R107

M050

D003

C074

7/25/2000

Jones

Jill

20783

Bambi

V099

S076

Adelphi

MD

$0.99

$100.00

R108

M177

D006

C211

7/25/2000

Smith

Bill

21114

Titanic

V127

S076

Crofton

MD

$3.00

$120.00

R109

M012

D006

C298

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

1. The data below are for an airline. Each flight can leave at any time from any airport and is identified by FlightID. Each flight is piloted by one and only one captain in an aircraft identified by...

Q:

CLASS: BUSINESS DATA MANAGEMENT Pay attention to: Draw arrows to show dependencies (full/partial/transitive) in the diagram. If it is not a 3rd normal form, you need to covert the diagram to 3rd...

Q:

These are database management questions and MS Access related questions When designing a database, named properties or characteristics that describe an entity ( and are of interest to the company)...

Q:

The staff at 'Frankli Consulting' have to routinely visit their clients in other cities. Franklin have a fleet of cars available for staff travels. During their trips, the staff sometimes need to...

Q:

Question 1 of 10 1.0 Points Which is NOT one of the responsibilities of the database administrator? A. Backup the database B. Do performance tuning C. Set up user authentication D. Determine data...

Q:

Homework #2 Please upload your homework as a Word document to Canvas by March 10 given sample data and normalize it into a A bookstore uses the following table to store data. Review this table along...

Q:

Page. 1 210.02 Lab 210.02 Data Normalization Lab (Revised 2/11/04) Data Normalization Basics This exercise consists of two exercises that will demonstrate your ability to normalize data using the...

Q:

4. Golf club GolfersUnite organizes golf tournaments for its members and their guests. They use the following TOURNAMENT RESULTS table to keep track of players, tournaments and results. If you are...

Q:

I need a Dependency Diagrams for each entity type (show that there are no partial or transitive dependencies). a complete E/R diagram that satisfies Third Normal Form, and complete Data Dictionary...

Q:

Page 1 of 3 Project Assignment 1 - Normalization Due 3/11 Order ID Order Date Cust ID Cust Cust FName LName Sales Rep ID Sales Sales Rep Rep Comm FName LName Class Comm Dept ID Rate Prod Quy Prod...

Q:

Draw a circle diagram of the eukaryotic cell cycle. Label all phases. Discuss what goes on in each of the phases on the diagram. Note where checkpoints exist. Also, discuss G 0 , and discuss cell...

Q:

Microsoft is the worlds most successful software company. Bill Gates and Paul Allen founded it in 1975 with the original mission of having a computer on every desk and in every home, running...

Q:

5 Directors owe their company a duty to exercise their powers only for a proper purpose. Explain what is meant by proper purpose and discuss the nature and scope of this duty. Illustrate your answer...

Q:

CT Corp Comprehensive Question Canadian Tire Corporation, Limited (Canadian Tire) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

Q:

1. LaunchPad for Real Communication offers key term videos and encourages selfassessment through adaptive quizzing. Go to bedfordstmartins.com/realcomm to get access to: LearningCurve Adaptive...

Q:

3. Read up on the history of some influential but now defunct music group (such as the Beatles, Public Enemy, or Nirvana). Did the group go through all the stages of group development outlined in...

Q:

5. The telephone game, passing a message from person to person, is fun simply because of the inevitable message distortion that gets revealed at the end. Can you think of a time when a message was...