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

Transcribed Image Text:

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% 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%

Answer rating: 100% (QA)

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 ... View the full answer