Question
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
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
Given the information in above table,
1. Draw a dependency diagram to show the functional dependencies existing between columns. State any assumptions you make about the data and the attributes shown in the table. (3 marks)
2. Show the step by step process of decomposing the above table into a set of 3NF relations. (5 marks)
3. Review the design of your 3NF relations and make necessary amendments to define proper PKs, FKs and atomic attributes. Make sure all of your attributes conform to the naming conventions. (3 marks)
4. Draw the Crows Foot ERD to illustrate your final design. (4 marks)
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 740872473Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started