MIS 470 Lpaper2 Ambulance Database

MIS 470 Lpaper2 Ambulance Database - THE AMBULANCE SERVICE...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
THE AMBULANCE SERVICE DATABASE 1 Case 5- The Ambulance Database L-Paper 2 MIS 470, T 2:00-4:30 Dr. Robert Mullen April 3 rd , 2007
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
THE AMBULANCE SERVICE DATABASE 2 Case Background Three unprofitable ambulance companies have merged to reduce cost and consolidate operations. The three companies are located in different areas of the town, and in the past, they have had some overlap of coverage. The new ambulance service has received complaints ranging from slow service and poorly trained EMTs. The three ambulance base stations have different call volumes and types of calls. My team, has been hired to create a Access database to fix the problems of this newly merged company. Description of the Problem The new ambulance company has several problems they need to address with the new system. The EMT’s have four different levels of training. The EMTs level dictate the types of emergencies they are qualified to work. One of the complaints has been that some EMT’s are not adequately trained to work on patients on the way to the hospital. In particular, one urban area has a high incident of violent crime. Only the highest trained EMT’s should be routed to these emergencies. Another area of town contains a large amount of retired people. The EMTs sent to this area need to be able to stabilize heart attacks. Many of the EMT’s have complained that they have not been paid for all the hours they work. Therefore, they need a reliable way to clock in and out of a shift. The EMTs, for legal reasons, need to be on record for which emergencies they respond. Each of the three original companies had their own base station and ambulances. The merged company is going to be using the same equipment and keep the same base station. The company owns several ambulances; some are better equipped than others. To take care of an
Background image of page 2
THE AMBULANCE SERVICE DATABASE 3 emergency properly, the company needs to know which ambulance is at what base station and which one is the best to take care of that particular emergency. The ambulance company receives calls usually via 911. The information from these calls needs to be recorded. The typical information is: call time, the time the ambulance arrive, the nature of the emergency and the address and zip code. The zip code is important for the tracking the areas of the calls. The company needs to know which areas have high call volume so they can staff and equip those stations accordingly. Description of the Solution The solution to tracking these varied needs will be done using Access, a relational database. Initially loading all the information into tables, we will be able to query any information needed to help the company make critical decisions. In order to get an idea of the different types of emergencies the ambulance company
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/18/2008 for the course MIS 470 taught by Professor Mullen during the Spring '07 term at S. Connecticut.

Page1 / 9

MIS 470 Lpaper2 Ambulance Database - THE AMBULANCE SERVICE...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online