Normalized ERD, Memo, and Database File Week 3

Taylor Ambulance Company

Scheduling System Entities and Attributes

Incident

Patient Name

Incident Address

Incident Description

Resource Sent

Personnel 1 Name

Personnel 2 Name

Personnel 2 Credentials

Personnel 2 Credentials

Nearest Hospital

Disposition of Incident

Billing

Incident ID

Diagnosis

Type of Equipment Sent

Material Used 1 Description

Material Used 2 Description

Material Used 3 Description

Material Used 4 Description

Material Used 1 Cost

Material Used 2 Cost

Material Used 3 Cost

Material Used 4 Cost

Trip Detail

Time Dispatched

Arrival Time

Type of Transport (Emergency, Non-Emergency)

Number of EMTs Staffed on Transport

Number of Paramedics Staffed on Transport

Shift Detail (1,2 or 3)

Final Arrival Time of Transport

Starting Odometer Reading

Ending Odometer Reading

Total Miles Travelled During Trip

Trip Detail Notes

Trip Detail 1 Description

Trip Detail 2 Description

Trip Detail 3 Description