Man Search 2. Practical Instructions - Protected View - Saved to this PC ces Mailings Review View Help can contain viruset. Unless you need to edit, it's safer to stay in Protected View. 1 Enable Editing 16 17 18 D. Sneer two will be called "wata Uutpur ana will include the ourpur from the required sections of your assignment Please submit your assignment based on the following scenario SCENARIO Previously you helped the Family Doctor Practice normalize its data to be used in a database. From the normalized data, tables have been created with the initial data loaded into them. However since then more appointments have been booked, new patients have been taken in and billing has been completed. They need your help setting up tools to add patients, make, complete and bill appointments! What you know (since Assignment #1). Patients have been arriving late for appointments causing issues with next appointment and staff. The practice wants to track when the Patient is late Patients have been asking for reminders to be sent to their email address 3 new patients have been registered with the practice but aren't in the database yet Mary Sue, DOB: Oct 4, 1969, Health Card: 129483447, Address: 184 King St S, Kitchener, ON, N21 2M4, 519-884-8000, Email: (none) Chris McMann, DOB: Nov 11, 1981, Health Card 234144. Address: 38 Pinebush Rd, Cambridge, ON N2R 1M1, 519-667-8500, Email: cmcmann@rogers.com Karen Clinton, DOB: Dec 5, 2000, Health Card 1234555, Address: 389 Erb St E, Waterloo, ON NAR 404,519-588-1334, Email: kclinton@hotmail.com Appointments 10013 and 10014 have completed o 10013 was on-time, took 20 minutes, Notes: "Hands were burnt during cooking accident, bandaged up the scars and sent home for rest." Prescribed Tylenol 3. Billed $1,200, on April 4, 2019 @ 6:00 pm 10014 was late, took 30 minutes, Notes: "Patient is complaining about a sore foot when walking in heels. Noticed quite a bit of swelling and ask patient to use different shoes.". No medication prescribed. Billed $1,800, on April 4, 2019 @ 6:00 pm M Focal hp Man Search 2. Practical Instructions - Protected View - Saved to this PC ces Mailings Review View Help can contain viruset. Unless you need to edit, it's safer to stay in Protected View. 1 Enable Editing 16 17 18 D. Sneer two will be called "wata Uutpur ana will include the ourpur from the required sections of your assignment Please submit your assignment based on the following scenario SCENARIO Previously you helped the Family Doctor Practice normalize its data to be used in a database. From the normalized data, tables have been created with the initial data loaded into them. However since then more appointments have been booked, new patients have been taken in and billing has been completed. They need your help setting up tools to add patients, make, complete and bill appointments! What you know (since Assignment #1). Patients have been arriving late for appointments causing issues with next appointment and staff. The practice wants to track when the Patient is late Patients have been asking for reminders to be sent to their email address 3 new patients have been registered with the practice but aren't in the database yet Mary Sue, DOB: Oct 4, 1969, Health Card: 129483447, Address: 184 King St S, Kitchener, ON, N21 2M4, 519-884-8000, Email: (none) Chris McMann, DOB: Nov 11, 1981, Health Card 234144. Address: 38 Pinebush Rd, Cambridge, ON N2R 1M1, 519-667-8500, Email: cmcmann@rogers.com Karen Clinton, DOB: Dec 5, 2000, Health Card 1234555, Address: 389 Erb St E, Waterloo, ON NAR 404,519-588-1334, Email: kclinton@hotmail.com Appointments 10013 and 10014 have completed o 10013 was on-time, took 20 minutes, Notes: "Hands were burnt during cooking accident, bandaged up the scars and sent home for rest." Prescribed Tylenol 3. Billed $1,200, on April 4, 2019 @ 6:00 pm 10014 was late, took 30 minutes, Notes: "Patient is complaining about a sore foot when walking in heels. Noticed quite a bit of swelling and ask patient to use different shoes.". No medication prescribed. Billed $1,800, on April 4, 2019 @ 6:00 pm M Focal hp