Download
example erd n.
Skip this Video
Loading SlideShow in 5 Seconds..
EXAMPLE ERD PowerPoint Presentation
Download Presentation
EXAMPLE ERD

EXAMPLE ERD

1034 Vues Download Presentation
Télécharger la présentation

EXAMPLE ERD

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