can u draw the entity relationship diagram (is logical model rather than conceptual model)include the primary key and foreign key based on this problem.thank u!

Monitoring and Evaluating Health Providers s evident from recent news reports, incompetent health providers can not only create embarrassing publicity for Queensland government officials but can result in major medical problems or even death for the patients involved. One possible approach to improving health care could involve the design and implementation of a monitoring and evaluation system of all health care providers in Queensland. Some of the information required includes but is not limited to (1) personal data on each health care provider, e.g., age, gender, training, location, and years in practice, (2) data about each treatment performed on each patient and the outcome of that treatment, (3) patient characteristics. e.g., demographic, ethnic, and lifestyle information, and (4) benchmark data, e.g., average and typical variation of treatment results for patients with various characteristics. As you build the monitoring and evaluating health providers system (MEHPS), keep in mind that collecting and analysing the data will be very costly and that tax- payers will be concerned that building and operating the system is a worthwhile expenditure of their tax dollars. Also keep in mind that both the health care provider data and the patient data are regarded as sensitive information. Because of your recent training in database design and information retrieval, Queensland Health has just hired you to design and build a monitoring and evaluation system for all Queensland health providers. If your system is successful, it will be implemented Australia wide. If you succeed, Queensland Health will pay you a fabulous bonus, the prime minister will have you over for dinner, etc. If you fail, however, not only will you be looking for another employer, but the media will do prime time stories implying that you are personally responsible for Queensland Health's loss of reputation. Monitoring and Evaluating Health Providers s evident from recent news reports, incompetent health providers can not only create embarrassing publicity for Queensland government officials but can result in major medical problems or even death for the patients involved. One possible approach to improving health care could involve the design and implementation of a monitoring and evaluation system of all health care providers in Queensland. Some of the information required includes but is not limited to (1) personal data on each health care provider, e.g., age, gender, training, location, and years in practice, (2) data about each treatment performed on each patient and the outcome of that treatment, (3) patient characteristics. e.g., demographic, ethnic, and lifestyle information, and (4) benchmark data, e.g., average and typical variation of treatment results for patients with various characteristics. As you build the monitoring and evaluating health providers system (MEHPS), keep in mind that collecting and analysing the data will be very costly and that tax- payers will be concerned that building and operating the system is a worthwhile expenditure of their tax dollars. Also keep in mind that both the health care provider data and the patient data are regarded as sensitive information. Because of your recent training in database design and information retrieval, Queensland Health has just hired you to design and build a monitoring and evaluation system for all Queensland health providers. If your system is successful, it will be implemented Australia wide. If you succeed, Queensland Health will pay you a fabulous bonus, the prime minister will have you over for dinner, etc. If you fail, however, not only will you be looking for another employer, but the media will do prime time stories implying that you are personally responsible for Queensland Health's loss of reputation