United Sydney Toll Company used a spreadsheet to keep track of the travelling and charging records of its customers. Customers are issued a toll pass so they can use all motorways without stopping to pay. Customers with multiple vehicles are given different toll passes linked to the same customer account. Different operators manage different sections of the motorway network. Customers are charged the total amount for the journey when entering and exiting the motorway network regardless of the number of motorway sections used. However, the record will break down the journey into different trips covering only one motorway network section. A toll plaza is the entry and exit point of the motorway network. There are multiple booths in a toll plaza. You are required to: a. Normalise the following spreadsheet into separate tables in the third normal form (3NF) (6 marks). b. Draw an Entity Relationship Diagram (ER Diagram) to represent the normalised tables you created in (a) above (14 marks). Download the following answer sheet to complete your question. United Sydney Toll Company used a spreadsheet to keep track of the travelling and charging records of its customers. Customers are issued a toll pass so they can use all motorways without stopping to pay. Customers with multiple vehicles are given different toll passes linked to the same customer account. Different operators manage different sections of the motorway network. Customers are charged the total amount for the journey when entering and exiting the motorway network regardless of the number of motorway sections used. However, the record will break down the journey into different trips covering only one motorway network section. A toll plaza is the entry and exit point of the motorway network. There are multiple booths in a toll plaza. You are required to: a. Normalise the following spreadsheet into separate tables in the third normal form (3NF) (6 marks). b. Draw an Entity Relationship Diagram (ER Diagram) to represent the normalised tables you created in (a) above (14 marks). Download the following answer sheet to complete your