Task Perform Normalization Crude Dataset Could Stored Relational Database Metrocabs Privat Q43783265
In this task, you will perform normalization on a crude datasetso that it could be stored as a relational database. MetroCabs is aprivate taxi company that offers cab hire services to their regularbusiness clients. You are provided the following data about some oftheir recent services. The data includes important details on whichclient hired a taxi on given dates. MetroCabs has a small number offull-time drivers who drive different cars based on vehicleavailability
Given the information in above table,
1. Draw a dependency diagram to show the functional dependenciesexisting between columns. State any assumptions you make about thedata and the attributes shown in the table. (3 marks)
2. Show the step by step process of decomposingthe above table into a set of 3NF relations. (5 marks)
3. Review the design of your 3NF relations and make necessaryamendments to define proper PKs, FKs and atomic attributes. Makesure all of your attributes conform to the naming conventions. (3marks)
4. Draw the Crow’s Foot ERD to illustrate your final design. (4marks)
HIGH HALILOLIVIT on a truue 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 ID 2 6 Driver Name Jeffrey Etheridge Driver’s License Number 924765319 Cab Hire Time 5/09/2019 14:20 7/09/2019 11:00 12/09/2019 16:45 Cab Details Subaru Impreza 2015 Toyota Camry 2007 Honda Civic 2009 124 Shaun Pickup Address 6 Kambara Dr, Mulgrave 14 Gainsborough Ave, Wheelers Hill 6 Kambara Dr, Mulgrave 52 Brunswick Rd, Mitcham 8 Columbia Ave, Croydon Sam Harper 740872473 18 6/09/2019 20:10 Sanjay Ugle 843785124 345 Patrick 34 Ford Falcon 2010 Jeffrey Etheridge 924765319 Vipul Jad 6/09/2019 22:30 3/09/2019 09:00 12/09/2019 13:15 15/09/2019 18:05 723596201 521087243 209 Sarah Toyota Camry 2007 Ford Falcon 2010 Holden Commodore 2012 21 Devon St, Chaltenham 34 29 Ishan Mishra Sam Harper 740872473 Show transcribed image text HIGH HALILOLIVIT on a truue 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 ID 2 6 Driver Name Jeffrey Etheridge Driver’s License Number 924765319 Cab Hire Time 5/09/2019 14:20 7/09/2019 11:00 12/09/2019 16:45 Cab Details Subaru Impreza 2015 Toyota Camry 2007 Honda Civic 2009 124 Shaun Pickup Address 6 Kambara Dr, Mulgrave 14 Gainsborough Ave, Wheelers Hill 6 Kambara Dr, Mulgrave 52 Brunswick Rd, Mitcham 8 Columbia Ave, Croydon Sam Harper 740872473 18 6/09/2019 20:10 Sanjay Ugle 843785124 345 Patrick 34 Ford Falcon 2010 Jeffrey Etheridge 924765319 Vipul Jad 6/09/2019 22:30 3/09/2019 09:00 12/09/2019 13:15 15/09/2019 18:05 723596201 521087243 209 Sarah Toyota Camry 2007 Ford Falcon 2010 Holden Commodore 2012 21 Devon St, Chaltenham 34 29 Ishan Mishra Sam Harper 740872473
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