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.

(c) Determine the multiplicity constraints for each relationship.

(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

To what other attacks might a user of one-time passwords be

Show that an eavesdropper can gain access to the remote server with a relatively modest number of guesses. Hint: The eavesdropper starts guessing after the original user has

Convert the floating point number to ieee

Convert the floating point number to IEEE Single Precision Floating-Point Representation and For the following 8-bit data, using 2's complement to conduct the following calcul

The time has come for xelpharm to expand

The time has come for XelPharm to expand. The board of directors has purchased another warehouse for a second distribution facility. It's located in an industrial area, abou

Can an 00 approach be used to develop any system

Can an 00 approach be used to develop any system? What are the strengths of object orientation? What are its weaknesses? Give an example of a system where object orientation

Find the power rating of the electric heater

A 4-m 3 5-m × 6-m room is to be heated by an electric resistance heater placed in a short duct in the room. Initially, the room is at 15°C, and the local atmospheric pressur

Assessment of the case study

Write 2-3 page explaining the laws of the internet has benefit or limited E-commerce. Provide specific examples. You may use additional data sources to supplement your asses

What appear to be pointers to data within a heap object

In a strongly typed language like Java all variables and fields have a fixed type known at compile-time. What run-time data structures are needed in Java to implement the ma

Create a query from an existing query

You will create a relationship between two tables, create a query from an existing query, and create queries using text, numeric, compound, and wildcard criteria based using


Write a Review

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd