he 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
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
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
Step by step
Solved in 8 steps with 1 images
