Service Request SR-ta-001

Service Request SR-ta-001

Mission-Every 9 minutes someone in the city of Kelsey needs and ambulance. Taylor Ambulance Company is ready to respond. We will be there quickly & provide the best
possible emergency care.

History-Taylor Ambulance was started in 2000. They started out with 5 used ambulances. The company has expanded to 26 vehicles. In 2008, the company contracted with the city of Kelsey to provide emergency transport services. Today, Taylor Ambulance Company employs 95 people and last year it made over 43,000 medical transports.

Service Request SR-ta-001 -The Taylor Ambulance Company would like to replace their paper unit scheduling system with something electronic.

This is the current system’s 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
Number of personnel responding
Distance Travelled
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

The paper needs to cover:
Complete the service request SR-ta-001
-Do a 300 word memo to the Technical Services/Logistics
Manager at Taylor Ambulance explaining the database design you will use. How your electronic solution will cover their needs from a management perspective. Create an ERD. Create a Microsoft Access database using the ERD.

 
ORDER THIS ESSAY HERE NOW AND GET A DISCOUNT !!!

You can place an order similar to this with us. You are assured of an authentic custom paper delivered within the given deadline besides our 24/7 customer support all through.