Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

CoxMovie operates an online movie rental service. For a limited time, customers can rent a movie by download it to their computer or view

CoxMovie operates an online movie rental service. For a limited time, customers can rent a movie by download

CoxMovie operates an online movie rental service. For a limited time, customers can rent a movie by download it to their computer or view the movie online. Each movie has been assigned a theme for classification. A customer is able to rent multiple movies at the same time. Customers need to join a membership class by paying an annual fee before they are allowed to rent a movie. Each membership class provides a different discount to the rental fee. The following is an extract of the CoxMovie data file. You are required to (1) normalise it to tables in the third normal form (3NF); (2) create an Entity Relationship Diagram to represent the normalised tables in (1) -- (Total marks = 20). CustID FName LName Phone MovielD 1011 Simon Smith 0412143212 101 1035 Jian Zhang 0404104123 101 2315 Dylan Singh 0414123456 102 2315 Dylan Singh 0414123456 103 1011 Simon Smith 0412143212 151 1011 Simon Smith 0412143212 153 Name of Table 1. 2. 3. Use the following table to represent your tables in 3NF (note: you may not need all tables below) 5. 1 N 1. Name of Table 2. 3. Movie Name Year ThemelD The World is not Enough 1999 A1 The World is not Enough A1 1999 1978 Grease 2015 1986 2018 4. A Brilliant Young Mind Top Gun Mission Impossible-- Fallout 5. Name of Table 1. 2. 3. + 4. 5. M3 D4 W3 A1 Theme Name Action Action Musical Drama War Action Name of Table 2. 3. 4. 2 Silver Date Rented MemClass ClassName 12/05/2020 1 Gold 15/06/2020 18/06/2020 22/06/2020 25/06/2020 12/05/2020 3 3 1 1 5. Name of Table 1. 2. 3. 4. Bronze Bronze Gold Gold 5. Discount 15% 10% 5% 5% 15% 15%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

I see you have provided a table of data from an online movie rental service named CoxMovie and the task to normalize the data to the third normal form 3NF and create an Entity Relationship Diagram ERD ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Microeconomics

Authors: Austan Goolsbee, Steven Levitt, Chad Syverson

1st Edition

978-1464146978, 1464146977

More Books

Students also viewed these Accounting questions

Question

What are the responsibilities of the position?

Answered: 1 week ago