QUESTION 3 Continuing from the above case study, Sioux Medical Group offers a holistic approach to healthcare with an emphasis on preventive medicine as well as traditional medical care. In your role as an IT consultant, you will help Sioux to develop a new information system. Background After completing the user interface, input, and output design for the new information system, you will now focus on the data design of the database management system (DBMS) that will support the system. Begin by reviewing the data flow diagrams (DFD) that you prepared above and the object models as per given at Appendix 1: a. Design the Entity Relationship Diagram (ERD) for the new system that should contain minimum of eight entities. (15 marks) b. Normalize your designs for all tables to ensure that they are in 3 normal form (3NF). (10 marks) APPENDIX 1 1. Case diagram for Make or Change Appointment or Remind the Patient: Requests Appointmen Confirms Checks Appointment Availability Make or Change Appointment Office Staff Paten t Initiates Reminder Notifies Remind Patient 2. Case diagram for Establish New Patient and Update Patient Records follows: q Provides Patient Establishes New Office staff Patient Changes Updates Existing Provides Medical Informatio n Update Records Medical Staff 3. Case diagram for Bill Patient and Submit Insurance Claim follows: > to Reques Submits Bill Bill Patient Office Staff Patien Update Requests sto Submit Insurance Claim Pays or Denies Claim QUESTION 3 Continuing from the above case study, Sioux Medical Group offers a holistic approach to healthcare with an emphasis on preventive medicine as well as traditional medical care. In your role as an IT consultant, you will help Sioux to develop a new information system. Background After completing the user interface, input, and output design for the new information system, you will now focus on the data design of the database management system (DBMS) that will support the system. Begin by reviewing the data flow diagrams (DFD) that you prepared above and the object models as per given at Appendix 1: a. Design the Entity Relationship Diagram (ERD) for the new system that should contain minimum of eight entities. (15 marks) b. Normalize your designs for all tables to ensure that they are in 3 normal form (3NF). (10 marks) APPENDIX 1 1. Case diagram for Make or Change Appointment or Remind the Patient: Requests Appointmen Confirms Checks Appointment Availability Make or Change Appointment Office Staff Paten t Initiates Reminder Notifies Remind Patient 2. Case diagram for Establish New Patient and Update Patient Records follows: q Provides Patient Establishes New Office staff Patient Changes Updates Existing Provides Medical Informatio n Update Records Medical Staff 3. Case diagram for Bill Patient and Submit Insurance Claim follows: > to Reques Submits Bill Bill Patient Office Staff Patien Update Requests sto Submit Insurance Claim Pays or Denies Claim