Task Perform Normalization Crude Dataset Could Stored Relational Database Metrocabs Privat Q43803525
In this task, you will perform normalization on a crude datasetso that it could be stored as a relational database.
MetroCabs is a private taxi company that offers cab hireservices to their regular business clients. You are provided thefollowing data about some of their recent services. The dataincludes important details on which client hired a taxi on givendates. MetroCabs has a small number of full-time drivers who drivedifferent cars based on vehicle availability.
Client IDClient NameCab Hire TimeCab IDCab DetailsPickup AddressDriver NameDriver’s License Number124Shaun5/09/2019 14:2026Subaru Impreza 20156 Kambara Dr, MulgraveJeffrey Etheridge9247653197/09/2019 11:0011Toyota Camry 200714 Gainsborough Ave, Wheelers HillSam Harper74087247312/09/2019 16:4518Honda Civic 20096 Kambara Dr, Mulgrave345Patrick6/09/2019 20:1034Ford Falcon 201052 Brunswick Rd, MitchamSanjay Ugle8437851246/09/2019 22:308 Columbia Ave, CroydonJeffrey Etheridge924765319209Sarah3/09/2019 09:0011Toyota Camry 200721 Devon St, ChaltenhamVipul Jad72359620112/09/2019 13:1534Ford Falcon 2010Ishan Mishra52108724315/09/2019 18:0529Holden Commodore 2012Sam Harper740872473
Given the information in above table,
4. Draw the Crow’s Foot ERD to illustrate your final design. (4marks)
For guidance on how to normalise database relations from adependency diagram, watch this very short video:https://www.youtube.com/watch?v=vkUyuLLgmwQ
All dependency diagrams and ERD must be created using a drawingtool. Hand-drawn diagrams are NOT acceptable.
Expert Answer
Answer to In this task, you will perform normalization on a crude dataset so that it could be stored as a relational database. Met…
OR