Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1 ) Create a conceptual data model using Enterprise Architect ( EA Academic ) based on the information under. 2 ) Create a logical data

1) Create a conceptual data model using Enterprise Architect (EA Academic) based on the information under.
2) Create a logical data model for a relational database based on (1) the information above, and (2) your conceptual data model.
Huber Taxi
A private taxi company called Huber Taxi was established in Newyork in 2020. Since then, the company has grown steadily and now has offices in most of the main cities of USA. 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, Jon Olsen 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 Huber Taxi.
The Director has provided the following brief description of how Huber Taxi 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 Huber Taxiand each taxi is allocated for use to a number of drivers. The majority of owners are also drivers.
HuberTaxitaxis 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.
here 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 Huber Taxi will undertake for a fixed fee.
When a job comes into Huber Taxi 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.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Database Systems

Authors: Ramez Elmasri, Sham Navathe

4th Edition

0321122267, 978-0321122261

More Books

Students also viewed these Databases questions

Question

Discuss the history of human resource management (HRM).

Answered: 1 week ago