Identify the main entities of fast cabs

Assignment Help Basic Computer Science

Reference no: EM131216707

Read the following case study for a brief description of a taxi company called Fast Cabs. 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 Fast Cabs and each taxi is allocated for use to a number of drivers. The majority of owners are also drivers. Fast Cabs 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 Fast Cabs will undertake for a fixed fee. When a job comes into Fast Cabs 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 job ID. 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.

(a) Identify the main entities of Fast Cabs.

(b) Identify the main relationships between the entities.

(d) Identify attributes and associate them with an entity or relationship.

(e) Determine candidate and primary key attributes for each entity.

(f) Using your answers (a) to (e) represent the data requirements of the Fast Cabs as an enhanced ER (EER) model. (Hint: Use optional Step 1.6 of the methodology to identify private clients (subclass) and business clients (subclass) as being special types of clients (super class).) State any assumptions necessary to support your design.

Reference no: EM131216707

Questions Cloud

What additional information or considerations would you need : If you are rejecting the invitation, what additional information or considerations would you need to eliminate your apprehensions in order to accept this invitation?

How is the theme developed through text and illustrations : In what ways do the illustrations help create the meaning of the text? Do the illustrations extend the text in any way? Do they provide clues to the action of the story? Explain your answer.

Determine the maximum value of the voltage transfer function : Determine the maximum value of the voltage transfer function. - Determine the frequencies at which the magnitude is 1/ √2 of the peak value.

How does your answer explain your ultimate life goals : How does your answer explain your ultimate life goals? Expectations? Hopes? Fears? Purpose? If it does not explain any of these things, why not?

Identify the main entities of fast cabs : Using your answers (a) to (e) represent the data requirements of the Fast Cabs as an enhanced ER (EER) model. (Hint: Use optional Step 1.6 of the methodology to identify private clients (subclass) and business clients (subclass) as being special t..

What is the maximum voltage gain : The transistor is biased at IDQ = 0.8 mA. - What is the maximum voltage gain? - What is the bandwidth?

Compare your er model with the answer er model : Compare your ER model with the answer ER model and justify any differences found.

Analyze the types of care your chosen organization focus on : Analyze the types of care or service your chosen organization focus on. Analyze the mission. Analyze the QI goals the organization has in place.

Determine rc and determine the maximum gain : The circuit bandwidth is 800 MHz and the quiescent collector-emitter voltage is VCEQ = 1.25 V. - Determine RC.- Determine the maximum gain.

User Account

All Pages