Final Exam Name: Student ID: 1. Quick-Cab is a small independent taxi

Final Exam

Name:

Student ID:

1. Quick-Cab is a small independent taxi company operating in a major city. Quick-Cab owns 50 taxis which it rents out to drivers on an annual basis. Each vehicle is effectively rented out to three drivers to cover three 8 hour shifts in a day, therefore there are 150 taxi drivers contracted to Quick-Cab at any given time. Quick-Cab is a profitable company because it has built up a good reputation locally, and there is always a waiting list of drivers wanting to apply to rent a vehicle. 

Each driver pays an annual rental fee in advance to Quick-Cab giving them use of a vehicle for 8 hours a day every day of the year. In addition to the annual rental, Quick-Cab takes 5% of the money a driver earns every week. Quick-Cab is responsible for taxing, insuring and maintaining the vehicles. If a vehicle is due for a service or needs to be repaired Quick-Cab contacts a garage and arranges it. Quick-Cab keeps an account of the repair and service costs for each vehicle. 

At the end of each shift drivers give the money they have earned to Quick-Cab. If they needed to refuel the vehicle they also submit an expense claim at the end of the shift. At the end of every week Quick-Cab calculates the amount owing to each driver based on the money earned from fares, the expense claims and the deduction of 5%. The drivers are then paid.

Identify the entities, major processes, and data stores for each process for Quick-Cab.

Draw the Data Flow Diagram for Quick-Cab

Write the pseudo-code for any one process

2. For calculating employee wages, each department sends HR the following information to HR:

Employee ID

Department ID

Regular Hours Worked

Overtime Hours Worked

Days Worked

Days Absent

However, it was observed that there were numerous problems encountered in accurately computing wages. The problems included, wages going to the wrong employee, incorrect department codes, incorrect entry of hours worked, overtime paid and number of days for which the wages were calculated.

As a systems analyst what checks you would recommend to ensure that each of these errors are minimized.

The employee ID is a 5-digit numeric code. Do you think incorporating check-digit in employee id would help? If so, show how the Modulus-10 check-digit is computed by an example and describe how it can reduce errors.