Question: Design an E-R diagram for modeling a small clinic database. The database models the patients, doc- tors, the patients visits to the doctors, the doctors

Design an E-R diagram for modeling a small clinic database. The database models the patients, doc- tors, the patients visits to the doctors, the doctors prescription of medications to the patients, and the patient's insurance policies, and the claims filed on the policy Assume the following (1) Each patient is modeled by P_ID, name, age, address and phone_number (2) Each doctor is modeled by D_ID, name, and speciality (3) Each medication is modeled by M_ID, name, dosage, and price (4) Each insurance company is modeled by Insure ID, name, address, and phone_number (5) Each insurance policy is modeled by Policy_ID, name_of_insured, and effective_date (6) Each claim is modeled by Claim ID, amount, date clainm (7) Each patient can visit one or more doctors (on the same day, or on different days - so you need to model the date of the visit), and each doctor can be visited by zero or more patients (8) The "prescription is an m-m-m relationship among doctors, patients and medications - although you can also model "prescription" as an entity. For each prescription, you want to model the date of the prescription and quantity of the medications prescribed (9) Each patient has zero or more insurance policies, and each policy is issued by exactly one nsurance company (10) Each insurance policy has zero or more claims
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
