I need help completing this project.  You are building a data base for this fictitious Taxi company.  Please dont copy and paste things from off the internet...

ISYS 3293 System Analysis and DesignFall 2016RazorCab Company, Inc.RazorCab Company is licensed to operate a taxi cab service in the northwest Arkansas area.The company hasbeen in business for the past seven years.Your role is to analyze and design a system for this company based onthe system service request.The Company owns a fleet of 65 cabs.All the cabs are of the same make and model.However, they may befrom different years.The Company is organized into three departments: Dispatching, Maintenance, andManagement Control.The Dispatching department does the following activities: dispatching cabs, schedulingdrivers, and keeping record of operating expenses and revenue.The Maintenance department takes care ofpreventive maintenance and repairs of the vehicles.It has sufficient excess capacity to provide services toexternal customers and does so.The Management Control department is responsible for planning, policysetting, financing, payroll, accounting, recruitment, etc.Management Control periodically advertises and receives applications for cab drivers.It carefully scrutinizesapplications especially police records, prior employment history, etc. and makes recruitments and keeps themon file.Most of the applications are usually from part-time work seekers.Given that the number of cab driversis far more than the available number of cabs, work is uniformly distributed amongst the drivers in a round-robin fashion.Cab drivers are guaranteed 80 hours every two months.Every month, management selects cabdrivers that are to work that month and passes the information to dispatching department.The Dispatchingdepartment is responsible for detailed daily and weekly scheduling.Also, given that cab drivers have differentpreferences regarding working hours, efforts are made to satisfy their preferences equitably.There is no limiton the number of hours a cab driver may elect to work after they have been employed for six months, prior tothis, new cab drivers are allowed only to work 8 hours in a work day, and no one is allowed to work more than12 hours in a day.At the beginning of the work-shift, a cab driver visits the company premises to pickup his or her cab.They fillout a “shift work sheet form.”It has two sections: “pickup information” and “drop back information.”Pickupinformation includes driver name, identification number, cab number, cab status, mileage, fuel level, pick uptime, etc.Usually they deliver the cab back to the premises.At that time they fill out “drop back” details likemileage, fuel levels, fill-ups made, number of journeys made, details of each journey, fares collected, tipscollected, etc.The Dispatching department may sometimes allow cab drivers to take the cab home ifcircumstances permit and demand.The Dispatching department hands cabs over to the Maintenance department both for routine preventivemaintenance as well as for any repairs.Necessary repairs are reported by drivers in the “drop back” details.Customers usually call-in for cabs.They give their location and approximate time of pick-up.They alsoinquire about fares and lodge complaints.The maximum advance reservation is 24 hours with the exception ofairport pickups and drop offs which can be scheduled as far out as 4 weeks.The company has divided its operations region into 10 areas.On receiving a call from customers, the dispatcherchecks for any available cab in that area, or in the neighboring areas and informs the customer when the cabwill arrive and the approximate fare.Because some areas are more lucrative than others (e.g., area 2 containsthe NW Arkansas airport), cab drivers must be rotated through area assignments in a fair manner.1

• 1493971644-Data Base Project.doc

ComputerScienceExpert

(11)

Status NEW Posted 05 May 2017 08:05 AM My Price 9.00

-----------

Attachments

file 1493971647-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer