Is the erd crows foot notation drawn for the case study correct DriverPK Driver_IDNameFK Vehicle_IDContact1,Nassigned1,NworkVehiclePK Vehicle IDModelRegistrationCapacitybooksNameSurnameCustomerPK Customer_IDAddressNO,NKPhone_numberShiftPK Shift_ID1depart_timereturn_timerest_timeusedMincludesO,NTripPK Trip_IDArrival timeDepature_timeTrip_durationNbooksNRoutePK Route_IDMRoute_descriptionRoute_businessRoute distancefollowsPickup pointPK Pickup_IDCo-ordinatesTypeAddress Practice Case Study: Mike's BikesMike's Shuttle Services, our case-study business, is a new shuttle business. The business startedsmall with Mike transporting customers to key locations in Cape Town such as Cape TownInternational Airport regularly. In spite of a lot of competition, his business has steadily grown andhe acquired a few shuttle mini-buses recently. He applied for all the necessary licenses and wasapproved to he can now legally operate a shuttle business. He subsequently also reached out andco-opted the services of a shuttle drivers. His aim is of course to let his vehicles do as many tripsas 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 recordsbookings he receive on paper so that he can schedule the vehicles and drivers. Mike spends a lotof time maintaining all of this data and his current process is error prone because the schedulingof trips and customers, as well as vehicles and drivers, is a complicated process. He managed toacquire 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 heperforms on the computer is an attempt to keep track of the vehicles and their necessarymaintenance and roadworthiness using a spreadsheet program. This is done because he isworried about the roadworthiness of the vehicles and the fact that they could be impounded bytraffic 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 datarelated to his business. Using a database would greatly diminish the amount of time he currentlyspends maintaining his data, and he could always ensure that the data is up-to-date and that theinformation is accurate. Although he thinks a database is a good idea, he's aware of the fact thathe doesn't know the first thing about properly designing a database. Undaunted, Mike hasdecided 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 ComputerScience degree at UWC, and you are very enthusiastic to use your database design andprogramming 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 thefollowing 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 rules4. Develop the initial ERD5. Identify the attributes and primary keys that adequately describe entities6. Revise and review ERDAs a first step, you interviewed Mike and monitored his operations that were refined since heacquired the additional vehicles. You captured the following initial business rules:• Each of the shuttle vehicles are used for several trips each day.• All trips are round trips and trips depart from the depot (at Mike's premises) at aspecific time towards a final destination such as Cape own International Airport, the V&AWaterfront or a hospital (e.g. Groote Schuur).• A trip follows a specific route and picks up customers along the way at pre-arranged pick-uppoints.• The information about pick-up times are available and customers then book trips and indicatetheir pick-up point at a specific time. They do this primarily via WhatsApp and Mike keep a recordon paper which he gives to drivers when they depart from the depot. This list indicates whichcustomers must be picked up at which pick-up point.• Sometimes a customer can book a special pick-up at extra cost if the shuttle can accommodatethis request. These special cases would include an ill or disabled patient that has to go tohospital.• Drivers work in a shift - a shift starts at a specific time when the shuttle and driver depart at thedepot and then when they return. There is a compulsory rest time for drivers between shifts(minimum 2 hours), so sometimes drivers may work more than one shift a day. Shift durationsdepend on the length of the trip as well as how busy the route normally is.• Sometimes a shift may include more than one trip, sometimes only one, it depends on thedistance of the trip.• A shift implies that a driver is assigned a shuttle vehicle for that shift, so a driver may beassigned to more than one shuttle a day and a shuttle may have more than one driver a day.

Question

Accepted Answer

The "Practice Case Study: Mike's Bikes" is a fictional scenario or case study used for educational…