The Johannesburg Athletic Club Association (JACA) is an organisation that encourages the city's population to join athletic clubs by discounting the amount that each athlete spends on the registration...

Extracted text: The Johannesburg Athletic Club Association (JACA) is an organisation that encourages the city's population to join athletic clubs by discounting the amount that each athlete spends on the registration fee of each race based on the club that the athlete is a part of. The organisation would like you to assist them in tracking the discount they need to provide to the top three runners of each race. They have given you a spreadsheet with an extract of some races and the runners involved. QLUB DISCOLNT DISCOUNTED FEE R232.50 R237.50 R237.50 R190.00 R190.00 RO00.00 RS80.00 R372.00 R372.00 RACE RUNNER Nobulo Dube 5 May 2015 RIS0.00 Pie Mabuti acenra Smith Erlinda Buckman 2 Sest 2015 8200.00 Dominick Mihize Dannette Camillo Sborgile Mbele 18 Nov 2015 400.00 Sebastian Bass thabiso Mohapi DATE FEE TIME 1H.07 Bramfie Runners IH:11 Rosbank Nke Club IH24 Branfie Runners IH09 Team Vitality IH12 Soweto Running Club The Winter Half Marathon The Spring Spring Halif Merathon 1H19 OH38 Soweto Running Club OH40 Brantie Runners OH43 Branfie Runners The Colour Run 716 5.1 In which Normal Form is the above table? Explain how you arrived at your answer. 5.2 Explain the steps to convert an unnormalized table into 1st Normal form. 5.3 Explain the conditions required for a table to be in BCNF Normal form. 5.4 Explain where 4th Nomal form is usually used. 5.5 Which Normal form will have the least number of anomalies? 5.6 Convert the given table into 3rd Normal form. Write your answer as a relation Schema. 5.7 Define Normalization 5.8 Define Denormalization