Question

E-R model creation help

I need help creating a E-R model for a healthcare.

In the hospital, there are several rooms. Each room has an ID general description of equipment in rooms.Each room can be scheduled with multiple test and each IR test will be scheduled and conducted in only one room.

The test, will be a key(encounter number) displays the associated date of service, provider and time of appointment which will key. It included the start time and end time from the test. We can gather the test duration which can be later used to calculate the room utilization. Please note some test will require anesthesia before the test start. Does it require anesthesia or not because duration can be later used to calculate the room utilization.

*physician have a ID, name, beeper number, telephone number, address, and specialty . physician are scheduled with none to multiple room (test)

*patients one or multiple rooms test scheduled. Patients have ID’s number, name, gender, address. Patients can be inpatient or outpatient. For inpatient we also have a waiting lobby that records where the patient is transported to and get prepared for the test. Outpatient, we will record the scheduled test time.

Answer 1

enhit'os Rooms L -, entites Sched le Sch IR Teat Nama in endan use No

• Required Entities are : Physician,Rooms,Tests,Patients,outpatients,inpatients,waiting Lobby,Anesthesia,IR Test
• Multivalued Attributes can have more than one possible values.
• Primary Key stands for a unique identification of an entity.