Answered step by step
Verified Expert Solution
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
Create a conceptual data model using Enterprise Architect EA Academic based on the information under.
Create a logical data model for a relational database based on the information above, and your conceptual data model.
Huber Taxi
A private taxi company called Huber Taxi was established in Newyork in 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 everincreasing 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 shortlived 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 daytoday 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 pickup datetime and pickupdropoff addresses are noted. Each job is allocated a unique jobID. The nearest driver to the pickup 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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started