MAKE AN ER DIAGRAM FOR THE FOLLOWING PROMPT: Various physicians are working for a clinic and these doctors are identified by their respective employee numbers. The other descriptors of a doctor are: name, gender, address, and phone. Each physician’s specialty and rank are captured. Every physician serves as a primary care physician for at least one patient; however, no more than 20 patients are allotted to a physician. Every patient is assigned one physician for primary care. Data for patients include: patient number (the unique identifier of a patient), name, gender, date of birth, blood type and the code and name of allergies, if any. Physicians may prescribe medications to patients; thus, it is necessary to capture which physician(s) prescribe(s)s what medication(s) to which patient(s) along with dosage and frequency. In addition, no two physicians can prescribe the same medication to the same patient. If a physician leaves the clinic, all prescriptions written by that physician should also be removed because this information is retained in the archives. A patient may be taking several medications, and a particular medication may be taken by several patients. Despite its list price, a medication’s cost varies from patient to patient, perhaps because of the difference in insurance coverage. The cost of a medication for a patient needs to be captured. Medications are identified by either their unique medication codes or by their unique names. Other attributes of a medication are its classification, list price, and manufacturer. For every medication, either the medication code or the medication name must be present—not necessarily both.
MAKE AN ER DIAGRAM FOR THE FOLLOWING PROMPT:
Various physicians are working for a clinic and these doctors are identified by their respective employee numbers. The other descriptors of a doctor are: name, gender, address, and phone. Each physician’s specialty and rank are captured. Every physician serves as a primary care physician for at least one patient; however, no more than 20 patients are allotted to a physician. Every patient is assigned one physician for primary care. Data for patients include: patient number (the unique identifier of a patient), name, gender, date of birth, blood type and the code and name of allergies, if any. Physicians may prescribe medications to patients; thus, it is necessary to capture which physician(s) prescribe(s)s what medication(s) to which patient(s) along with dosage and frequency. In addition, no two physicians can prescribe the same medication to the same patient. If a physician leaves the clinic, all prescriptions written by that physician should also be removed because this information is retained in the archives. A patient may be taking several medications, and a particular medication may be taken by several patients. Despite its list price, a medication’s cost varies from patient to patient, perhaps because of the difference in insurance coverage. The cost of a medication for a patient needs to be captured. Medications are identified by either their unique medication codes or by their unique names. Other attributes of a medication are its classification, list price, and manufacturer. For every medication, either the medication code or the medication name must be present—not necessarily both.
Step by step
Solved in 2 steps with 1 images