This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: insurance compnay can have many patients carry their policies. For patients that carry insurance, the insurance company will make payments, each single payment is made by exactly 1 insurance company. Given the above information, the following ERD can be drawn: is insured by *pat_idnumber pat_firstname pat_lastname pat_address pat_city pat_state PATIENT *ins_name ins_benefitscontact ins_phonenumber ins_claimsaddress INSURANCE COMPANY *pay_receiptnumber pay_amount pay_date pay_method PAYMENT *doc_physicianidnumber doc_firstname doc_lastname DOCTOR *bill_number bill_amountinsured bill_amountnotinsured bill_datesent bill_status BILL *app_date *app_time app_duration app_reason APPOINTMENT is scheduled for pays is made by generates makes schedules...
View Full Document
- Spring '10
- Business, single payment, following business rules, APPOINTMENT DOCTOR *doc_physicianidnumber, insurance company