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 *******19 7/09/2019 11:00 11 Toyota Camry 2007 14 Gainsborough Ave, Wheelers Hill Sam Harper *******73 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 *******24 6/09/2019 22:30 8 Columbia Ave
![[object Object]](/_next/image/?url=%2F_next%2Fstatic%2Fmedia%2Flogo.6d15ce61.png&w=640&q=75){kind=small}
![[object Object]](/_next/static/media/star-bottom.7253800d.svg)
