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 Discount 1011 1035 2315 2315 1011 1011 FName LName Simon Smith Jian Zhang Dylan Singh Dylan Singh Simon Smith Simon Smith Phone 0412143212 0404104123 0414123456 0414123456 0412143212 0412143212 MovielD Movie Name 101 The World is not Enough 101 The World is not Enough Grease 103 A Brilliant Young Mind 151 Top Gun 153 Mission Impossible - Fallout Year Themel 1999 A1 1999 A1 1978 M3 2015 D4 1986 W3 2018 A1 102 ThemeName Date Rented Action 12/05/2020 Action 15/06/2020 Musical 18/06/2020 Drama 22/06/2020 War 25/06/2020 Action 12/05/2020 MemClass ClassName 1 Gold 2 Silver 3 Bronze 3 Bronze 1 Gold 1 Gold 15% 10% 5% 5% 15% 15% Use the following table to represent your tables in 3NF (note: you may not need all tables below) Name of Table Name of Table Name of Table Name of Table Name of Table 1 1. 1. 1. 1. 2 2. 2. 2. 2. 3 3. 3 3. 3. 4 4 4 4. 4 4 5 5. 5. 5. 5. 6. 6. 6. 6. 6. 7 7. 7. 7. 7. 8. 8. 8. 8. 8