HIM350 Lab 4

I. Design an ER diagram (60%)

Additionally, you need to determine appropriate data types and keys. See Tables 1-6 below. You need to fill up all the necessary information in these tables. Some of the information is already there. Note that the ER diagram (Figure 1) is not a complete design. Therefore, you may or may not need to create additional attributes in Tables 1-6.

Table 1. Patient

Attributes	Data Types	Keys	References
Pat_idnumber	VarChar(10)	Primary key/ Foreign Key(2)	Appointment (pat_idnumber) Payment (pat_idnumber)
Pat_firstname	VarChar(20)
Pat_lastname
Pat_address	VarChar(30)
Pat_city
Pat_state

APPOINTMENT app date app time app duration app reason DOCTOR doc physicianidnumber doc firstname doc lastname is scheduled for schedules BILL generates bill number bill amountinsured bill amountnotinsured bill datesent bill status PATIENT PAYMENT makes pat idnumber pat firstname pat lastname pat address pat city pat state ays pay receiptnumber pay amount pay date pay method is made by is insured by INSURANCE COMPANY ins name ins benefitscontact ins phonenumber ins claimsaddress