Question 4: Normalisation (20 marks) The following question is based upon the APPOINTMENT relation below that lists details of appointments in a Podiatry Clinic StaffNo Podiatrist PatientName PatNum PatTelNo Appt Date Time Room No Room Ext 51011 Scott Bilstein Jill White P400 0159-254-369 10-JAN-20 0900 R2 7711 51011 Scott Bilstein lan Bell P8950148-427-83910-JAN-200930R2 7712 $1024 Harry Loper John Jamieson P3980001-568-03210-JAN-20 1000RB 7711 1024 Harry Lopez Gaye Gordon P669 0148-427-954 10-JAN-20 1030R2 7711 $1011 Scott Bilstein Ian Bell P89510148-427-83911-JAN-200845 R1 7711 510) Boris Wilson Gaye Gordon P669 10148-427-954 11-JAN-200845 R2 7712 StaffNo: Unique number used to identify each Podiatriste Podiatrist: The name of the Podiatriste PatientName: Name of the patient for whom the appointment has been booked PatNum: Unique number allocated to individual patients PatTelNo: Telephone number of the patiente Appt Date Time: The time and date when the appointment has been booked RoomNo: The room in which the appointment will take place RoomExt: The telephone extension number of the treatment room. 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. You need to write a report that addresses the following: a. What are the specific problems associated with the current design and why do they arise (about % page)? b. How would you change the current design and how does your new design address the problems you have identified with the current desien In order to receive high marks for this question, you will need to demonstrate an understanding of the theories discussed in Topics 1, 2 and 3 and how they apply to this problem. Simply providing the amended design (even if it is correct) will only attract a small percentage of the marks for this