This vignette is a small excerpt from a comprehensive case about a clinic. Vario

Question

This vignette is a small excerpt from a comprehensive case about a clinic. Various physicians and surgeons working for a clinic are on an annual salary (o). These doctors are identified by their respective employee numbers. The other descriptors of a doctor are: name, gender, address, and phone. Each physician's speciality and rank (o) are captured; each surgeon's speciality and skills are captured; a surgeon may have one or more skills.

Every physician serves as a primary care physician for at least seven patients; however, no more than 20 patients are alloted to a physician. Every patient is assigned one physician for primary care. Some patients need surgeries; others don't. surgeons perform surgeries for the patients in the clinic. Some do a lot of surgeries; others do a few. The date and operation theather (o) for each surgery needs to be recorded too. removal of a surgeon from the clinic database is prohibited if thst surgeon is scheduled to perform any surgery. However, if a patient chooses to pull out of the surgery schedule, all surgeries scheduled for that patient are cancelled.

Data for patients include: patient number ( the unique identifier of a patient), name, gender, date of birth, blood type, cholesterol( consisting of HDL, LDL, and triglyceride), blood sugar, and the code and namr of allergies if any.

Physicians may prescribe medications to patients; thus, it is necessary to capture which physican (s) prescribe (s) what medication (s) to which patient (s) along with do age 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 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. A medication may interact with several other medications. when a medication is removed from the system, it's interaction with other medications, if any, should be voided. when a patient leaves the clinic, all the medication records for that patient are removed from the system.

Medications are identified by either their unique medication codes or by their unique names. Other attributes of a medication are it's classification, list price, and manufacture(o). For every medication, either the medication code or the medication name must be present--not necessarily both.

Note: (o) indicates optional it of value for the attribute. Develop An ER model for this scenario

*I really need the CORRECT er diagram to match the summary. I THOUGHT this was the correct er diagram but its not so can anyone do the correct er diagram for this summary? I really need help ASAP

Address Phone Address Gender Address phone L Name Gendei M Name Doc-name . name'-9 F name oc - - Surgeons Doctor Emp_1d Emp_Id Price List medicines Medicationcode - Patnames - rescribes Suggest> Medications Patid - Pat no Patid at idPat prefix mr_1d . Patient Physian PatFname - - Pat M name Pat namre Gender Doc ame Pat L name Gender Address Phone -name M-NameName Blood Allergy L Name Cholesterol Intensity HDLO Name Type Sugar LDLO Triglyceride

Explanation / Answer

Consider the given E-R diagram:

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.