Reference no: EM131214092
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.
|
Identify processes involved in identifying business problems
: Identify the processes involved in identifying, formulating, and solving business problems? How do different inputs, such as environment and people, affect decision making?
|
|
Who at roanoke oversees the account review process
: Examination will give you practical experience in writing a business letter and doing prewriting for an informal report - Phoenix Advertising, with its main headquarters in Charlotte, North Carolina, serves clients that include banks, insurance comp..
|
|
Evaluate the stock of woolworths limited
: Assume that you are interested to evaluate the stock of Woolworths Limited. Go to Morningstar DatAnalysis Premium (http://datanalysis.morningstar.com.au.dbgw.lis.curtin.edu.au/af/dathome?).
|
|
Identify the pathophysiology of cardiovascular disorders
: Select one of the following alterations of cardiovascular disorders: peripheral arterial disease, myocardial infarction, coronary artery disease, congestive heart failure, or dysrhythmia. Think about how hypertension or dyslipidemia can lead to th..
|
|
Identify the main relationships between the entities
: 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..
|
|
Determine the appraised value
: Determine the appraised value. A fire station, built four years ago, has an estimated life of 50 years. The building has 20,000 square feet and the cost to replace is $100 per square foot. The lot is worth $120,000 vacant.
|
|
Obligation on the part of the holder
: What is the difference between holding a short call and a long put position? Does one of these positions results in an obligation on the part of the holder?
|
|
Find fred net capital gain for the current year
: Calculate Fred's net capital gain for the current year. Assume he also has a net capital loss from last year of $10,000 arising from the sale of shares
|
|
What skills be most important in future of nursing education
: Based on the projected visions of tomorrow's healthcare and nursing, what skills will be MOST important in the future of nursing education ( which skills need to be a priority in nursing schools of the future)? What are they and how should they be..
|