A hospital chain wants to model their appointment system. Their current appointments are kept in a spreadsheet system. All the hospitals are in similar buildings and having the same internal organization. A relevant historical fragment is provided below: Hospital Doctor Appointment Patient 9/7/2019 10:00AM Suite 2400 (Cardiology P10000121: Robert Brown (999-310-2241) D1001: Michael Jones (999-218-9933, 9/7/2019 10:20AM Suite 2400 (Cardiology second floor, follow blue circle) P10000123: Andrea mjones@fbh.com) second floor, follow blue circle) Garcia (999-324-9267) FBH: Fairfax Best Hospital (999-113- 2239, contact@fbh.com) D1002: William Miller (999-228-9933. third floor, follow orange square) 10/5/2019 10:20AM Suite 3100 (Dermatology P10000123: Andrea Garcia (999-324-9267) wmiller@fbh.com) 9/7/2019 10:00AM Suite 1200 (Critical care, first P20003728: Elizabeth floor, follow red triangle) Brown (999-335-1182) D2001: Mary Johnson (999-235-8365, mjones@abh.com) ABH: Arlington Best Hospital (998- 120-1124, contact@abh.com) 11/27/2019 8:00PM Suite 1200 (Critical care, first floor, follow red triangle) P20003728: Elizabeth Brown (999-335-1182) D2002: Patricia Rodriguez (999-241- 0043, prodrigues@abh.com) 1/24/2019 8:30AM Suite 2400 (Cardiology, second floor, follow blue circle) P20003728: Elizabeth Brown (999-335-1182) In addition the following business rules were identified: A doctor works in a single hospital. A hospital has many doctors. A doctor has many patient appointments. An appointment is for a given doctor. A patient has many doctor appointments. An appointment is for a given patient. Second Normal Form Convert the first normal form in second normal form. Draw the new dependency diagram. Include the 2NF diagram in your report. Third Normal Form Convert the second normal form in third normal form. Draw the new dependency diagram. Include the 3NF diagram in your report. Improved Third Normal Form How you can further improve the obtained diagram? Provide at least one improvement idea