Ch. 1: Project Exercise 1a

PATIENT PATIENTCHARGES

Billed_for

Billed_to

Relationship between PATIENT and PATIENT CHARGES:

Ch. 1: Project Exercise 1b

Name Type Length Min Max Description

Patient_LastName

Character 10 __ __

Patient’s last name

Patient_Number Integer 4 0 9999 Patient ID

Patient_Address Character 40 __ __ Street/City/State/Zip

Item_Description Character 20 __ __ Item name

Item_Code Integer 3 0 999 Item ID

Amount Decimal 7 0.00 99,999.99 Amount charged

Metadata

Patient_FirstName

Character 20 __ __

Patient’s first name

Ch. 1: Project Exercise 2a

Patient bill

Patient Name: Dolan, Mark

Patient Number: 4238

Patient Address: 818 River Run

Item Code Item Description Amount

200 Room Semi-Pri 1600

275 Radiology 150

700 EEG Test 200

Ch. 1: Project Exercise 3E-R diagram (simplified) for hospital

HOSPITAL PHYSICIAN

CHARGE PATIENT

WARD

On_staff

Works_in

Incurs

EMPLOYEE

Staffs

Admitted_by

Located_in

Has

Incurred_by

Admits

Has

Note: change the business rule in the question to: “A particular CHARGE is incurred by exactly one PATIENT”