Question

Create ER model

A private taxi company called FastCabs was established in Glasgow in 1992. Since then, the company has grown steadily and now has offices in most of the main cities of Scotland. However, the company is now so large that more and more administrative staff are being employed to cope with the ever-increasing amount of paperwork. Furthermore, the communication and sharing of information within the company is poor. The Director of the company, Paddy MacKay feels that too many mistakes are being made and that the success of his company will be short-lived if he does not do something to remedy the situation. He knows that a database could help in part to solve the problem and has approached you and your team to help in creating a database application to support the running of FastCabs. The Director has provided the following brief description of how FastCabs operates. Each office has a Manager; several taxi owners, drivers and administrative staff. The Manager is responsible for the day-to-day running of the office. An owner provides one or more taxis to FastCabs and each taxi is allocated for use to a number of drivers. The majority of owners are also drivers. FastCab taxis are not available for hire by the public hailing a taxi in the street but must be requested by first phoning the company to attend a given address. There are two kinds of clients, namely private and business. The business provided by private clients is on an ad hoc basis. The details of private clients are collected on the first booking of a taxi. However, the business provided by business clients is more formal and involves agreeing a contract of work with the business. A contract stipulates the number of jobs that FastCabs will undertake for a fixed fee. When a job comes into FastCabs the name, phone number and contract number (when appropriate) of the client is taken and then the pick-up date/time and pick-up/drop-off addresses are noted. Each job is allocated a unique jobID. The nearest driver to the pick-up address is called by radio and is informed of the details of the job. When a job is completed the driver should note the mileage used and the charge made (for private clients only). If a job is not complete, the reason for the failed job should be noted.

Answer 1

Create ER model-Fast Cabs

Admin1..1 Is a 1..1 Office 1..1 has a Staff し Office ID - Name Staff ID Office ID Name Phone Isa 1..1 Gender City 1..1 has a Manager 1..1 Private Client ID Staff ID 11 Gender age Staff ID Office ID 1..1 isa 1..1 Owner 1.1 isa Ext ID Staff ID External Client Client ID Name Phone Class 1..1 hasa Ext ID Name Phone Gender Age Business 1..1 Taxi 1. sa Plate No EXT ID Type Color Laddress 1.1 | Client ID 1..1 ContractID 1..1 1..1 hasa Isa Contract ContractID Staff ID Number of 1.1 Driver 1..1 Receipt Date pTime Job1..1 Ext ID hasa Plate ID Job Mileage Status Description Total mileage Staff No pAddress daddress Name Phone dass aess 1. 11 generates 1..1 1