In this task, you will perform normalization on a crude dataset so that it could be stored as a relational database.

MetroCabs is a private taxi company that offers cab hire services to their regular business clients. You are provided the following data about some of their recent services. The data includes important details on which client hired a taxi on given dates. MetroCabs has a small number of full-time drivers who drive different cars based on vehicle availability.

Client ID	Client Name	Cab Hire Time	Cab ID	Cab Details	Pickup Address	Driver Name	Driver's License Number
124	Shaun	5/09/2019 14:20	26	Subaru Impreza 2015	6 Kambara Dr, Mulgrave	Jeffrey Etheridge	924765319
		7/09/2019 11:00	11	Toyota Camry 2007	14 Gainsborough Ave, Wheelers Hill	Sam Harper	740872473
		12/09/2019 16:45	18	Honda Civic 2009	6 Kambara Dr, Mulgrave
345	Patrick	6/09/2019 20:10	34	Ford Falcon 2010	52 Brunswick Rd, Mitcham	Sanjay Ugle	843785124
		6/09/2019 22:30			8 Columbia Ave, Croydon	Jeffrey Etheridge	924765319
209	Sarah	3/09/2019 09:00	11	Toyota Camry 2007	21 Devon St, Chaltenham	Vipul Jad	723596201
		12/09/2019 13:15	34	Ford Falcon 2010		Ishan Mishra	521087243
		15/09/2019 18:05	29	Holden Commodore 2012		Sam Harper	740872473

Given the information in above table,

4. Draw the Crows Foot ERD to illustrate your final design. (4 marks)

For guidance on how to normalise database relations from a dependency diagram, watch this very short video: https://www.youtube.com/watch?v=vkUyuLLgmwQ

All dependency diagrams and ERD must be created using a drawing tool. Hand-drawn diagrams are NOT acceptable.