EXAMPLE ERD Create and ERD using UML notation

EXAMPLE ERD

Create and ERD using UML notation using the following rules: • A PATIENT can make many APPOINTMENTS with one or more DOCTORS in the clinic, and a doctor can accept appointments with many patients. However, each appointment is made with only one doctor, and each appointment references a single patient. • If kept, an appointment yields a VISIT with the doctor specified in the appointment. The visit yields a diagnosis and, when appropriate, TREATMENT. • With each visit, the patient’s records are updated to provide a medical history. • Each patient visit creates a BILL. Each patient visit is billed by one doctor, and each doctor can bill many patients. • Each bill must be paid. However, a bill may be paid in many installments, and payment may cover more than one bill. • A patient may pay the bill directly, or the bill may be the basis for a claim submitted for INSURANCE.

1. . 1 make 1. . * 1. . 1 DOC_ID (PK) 1. . 1 create * 0. . s re in * 0. . BILL n co ite ith dw ue iss kes ma VISIT_ID (PK) APP_ID (FK) DOC_ID (FK) 1 1. . PAT_ID (FK) DIAGNOSIS in 1 0. . 1 1. . 1 t ul lt su 1. 1 wr 1 f 1. . 1 to VISIT BILL PAYMENT BILL_ID (PK) * 0. . TREATMENT 1. . * link VISIT_ID (FK) DOC_ID (FK) 1. . 1 PAT_ID (FK) 1. . 1 paid in 1. . * 0. . * INSURANCE 0. . 1 link 1. . 1 INS_ID (PK) 0. . * BILL_ID (PK) (FK) PAY_ID (PK) (FK) 1. . 1 pays BILL_ID (FK) accept 1. . 1 yield par 0. . * TREAT_ID (PK) VISIT_ID (FK) 0. . * DOC_ID (FK) 1. . 1 APP_ID (PK) PAT_ID (FK) DOCTOR * PAT_ID (PK) APPOINTMENT 0. . PATIENT PAYMENT PAY_ID (PK) PAT_ID (PK) (FK) INS_ID (FK)