Hello i need help with normalising this question. Database design.

The following question is based upon the GRAND SLAM relation below that lists details of Grand Slam' tennis tournaments and their winners over the last few years. You can assume that the data is representative You have been asked to design a relational database based on this design. You know that there are problems with the current design and that it will need to be modified in order to work effectively. Answer the following questions. Each question is worth 5 marks What is the candidate key(s) of the relation? What normal form is the relation currently in? Explain your reasoning. Explain the problems with the existing design, in terms of the potential modification anomalies that it might exhibit. Convert the relation to a set of relations in at least Third Normal Form (3NF). You only need to show the schema, not the data. Do not create any new attributes. Give each of your new relations an appropriate name. Show all primary keys and foreign keys. a. b. c. d. Explain how your new design addresses the problems you identified in (b). Also demonstrate that your set of relaions has the dependency preserving and lossless join properties. GRAND SLAM Country Sponsor Dates LocationSurface Melbourne Hard Melbourne Hard Tournament Year Event Winner Australian Open 2016 Men's singles ak Djokovic SerbiaLacoste Melbourne Park 18-31 January 2016 Melbourne Park Flushing Meadows 29 August - 11 September 2016 New York Hard Flushing Meadows29 August-11 September 2016 New York Hard The All England ub The All England Club 27 June-10 July 2016 Roland Garros Roland Garros Melbourne Park Melbourne Park Australian Open 2016 Women's singles Angelique Kerber Germany Adidas 18-31 January 2016 2016 Wawrinka Switzeriand Yonex nyAdidas wimbledon-|2016]Men'ssingles- Ardwurrar_k__ 2016 Men's s Andy Murray 27 June-10 July 2016 London Grass Under Armour London Wimbledon2016 Women's singles Serena Wiams USA French Open2016 Men's singles French Open2016 Women's singles Garbine Muguruza SpainAdidas ger Federer izland Nike Melbourne Hard Melbourne Hard London 16-29 Nike winbedonteindlb 31 27 Wimbledon2017 Men's singlesRoger Federer Wimbledon French Open 2017 Men's singles French Open Adidas Nike Adidas 2017 Women's singles Garbine Muguruza Spain Garros28 May-11 Jun 2017 May1 un 2017 ael Nadal Roland Garros 2017 Roland Garros