1 / 3

EXAMPLE ERD

EXAMPLE ERD. Create and ERD using UML notation using the following rules:.

miles
Download Presentation

EXAMPLE ERD

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. EXAMPLE ERD

  2. 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.

  3. 0..1 link 1..1 1..1 make 1..* VISIT_ID (PK) APP_ID (FK) DOC_ID (FK) PAT_ID (FK) DIAGNOSIS 0..* accept 1..1 INSURANCE TREATMENT APPOINTMENT DOCTOR PATIENT BILL PAYMENT PAYMENT VISIT BILL PAT_ID (FK) PAT_ID (PK) (FK) INS_ID (FK) VISIT_ID (FK) DOC_ID (FK) PAT_ID (FK) PAY_ID (PK) (FK) VISIT_ID (FK) TREAT_ID (PK) BILL_ID (PK) BILL_ID (PK) (FK) PAY_ID (PK) APP_ID (PK) 1..1 DOC_ID (FK) BILL_ID (FK) DOC_ID (PK) PAT_ID (PK) INS_ID (PK) 1..1 1..* 1..1 1..1 part of 0..* consult in 1.1 1..1 0..* pays create yield 1..1 0..1 1..1 issued with 0..* 0..* write 1..1 1..1 makes result in 0..* 1..1 paid in 0..* 1..1 link 1..* 0..*

More Related