Practical Management Science
Practical Management Science
6th Edition
ISBN: 9781337406659
Author: WINSTON, Wayne L.
Publisher: Cengage,
Bartleby Related Questions Icon

Related questions

Question

The Case Study: Mike's Bikes
Mike's Shuttle Services, our case-study business, is a new shuttle business. The business
started small with Mike transporting customers to key locations in Cape Town such as Cape
Town International Airport regularly. In spite of a lot of competition, his business has
steadily grown and he acquired a few shuttle mini-buses recently. He applied for all the
necessary licenses and was approved to he can now legally operate a shuttle business. He
subsequently also reached out and co-opted the services of a shuttle drivers. His aim is of
course to let his vehicles do as many trips as possible, so his drivers are on a schedule to
rotate daily.
Mike has been conducting his daily business on paper and on his cell phone. He records
bookings he receive on paper so that he can schedule the vehicles and drivers. Mike spends a
lot of time maintaining all of this data and his current process is error prone because the
scheduling of trips and customers, as well as vehicles and drivers, is a complicated process.
He managed to acquire a second hand computer to assist him but at this stage he uses it
mainly to play games, write letters, and browse the internet and social media. The only
business-related task he performs on the computer is an attempt to keep track of the vehicles
and their necessary maintenance and roadworthiness using a spreadsheet program. This is
done because he is worried about the roadworthiness of the vehicles and the fact that they
could be impounded by traffic police if they are not roadworthy, especially when being used
to transport the public.
Recently, Mike learned that using a database would be a good way to store and work with
data related to his business. Using a database would greatly diminish the amount of time he
currently spends maintaining his data, and he could always ensure that the data is up-to-date
and that the information is accurate. Although he thinks a database is a good idea, he's aware
of the fact that he doesn't know the first thing about properly designing a database.
Undaunted, Mike has decided to hire a database consultant to design the database for him.
You are, in this story, the consultant Mike hired for the project. You completed your
Computer Science degree at UWC, and you are very enthusiastic to use your database design
and programming skills to develop a solution for Mike’s business.
As a first step you embark on the database design with an ERD. From your studies, you know
the following steps are required for building an ERD:
1. Create a detailed narrative of the organization’s description of operations (provided
above).
2. Identify business rules based on the descriptions.
3. Identify main entities and relationships from the business rules
4. Develop the initial ERD
5. Identify the attributes and primary keys that adequately describe entities
6. Revise and review ERD

Expert Solution
Check Mark
Knowledge Booster
Background pattern image
Operations Management
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Text book image
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Text book image
Operations Management
Operations Management
ISBN:9781259667473
Author:William J Stevenson
Publisher:McGraw-Hill Education
Text book image
Operations and Supply Chain Management (Mcgraw-hi...
Operations Management
ISBN:9781259666100
Author:F. Robert Jacobs, Richard B Chase
Publisher:McGraw-Hill Education
Text book image
Business in Action
Operations Management
ISBN:9780135198100
Author:BOVEE
Publisher:PEARSON CO
Text book image
Purchasing and Supply Chain Management
Operations Management
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Cengage Learning
Text book image
Production and Operations Analysis, Seventh Editi...
Operations Management
ISBN:9781478623069
Author:Steven Nahmias, Tava Lennon Olsen
Publisher:Waveland Press, Inc.