Question: 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

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,

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)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

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...

Q:

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...

Q:

Database Normalization 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....

Q:

The Cupid matchmaking Service maintains two files - one for the male clients and another for female clients. Each file contains a client ID, last name, first name, and address. Each file is in client...

Q:

You were requested to design a database to store the data concerning a large mechanic shop. Your database has to store the following: For each car, you want to store the make, model, year, color,...

Q:

Project Name: Gmail Setting Tab Functionality Test Client ID: Module / Component Name: Sub - Module / Feature Name: Test Case Name: Test of NextStop Website Functionalities REFERENCE DOCUMENTS Source...

Q:

What is the primary key of the "landscaping" table below? 1 0 options: First Name Client ID Last Name Technician Name

Q:

FIGURE 3-6 Top 5 Percent query Query 4 Create a query called Training Hours that lists the number of hours each dlient has trained within a specific rang Training should resemble the format shown in...

Q:

To provide file and device trajectory features, what is used by the AMP console to track AMP clients? IP address username AMP connector client ID computer name

Q:

Question 2 9 To provide file and device trajectory features, what is used by the AMP console to track AMP clients? IP address username AMP connector client ID computer name

Q:

Briefly discuss the conditions necessary for a taxpayer to be permitted to make tax-deductible contributions to a Keogh plan.

Q:

Can you explain what is meant by elasticity of supply and demand? Thank you so much!

Q:

Which of the following situations most likely represents the highest risk of a statement arising from misappropriation of assets a large number of inventory items with low sale prices a large number...

Q:

1. Type out equation and fill it in. 2. Put formulas into excel and show numbers and formula. LOAN FEES Loan amount of $60,000 Interest rate of 6% Term of 30 years Loan fee of 3% What is the...

Q:

(Appendices) PURCHASES RECORDED GROSS. Dawson Enterprises uses the periodic system and records purchases gross. On a recent day, Dawson engaged in the following three transactions: LO2 a) Purchased...

Q:

(Appendices) UNCOLLECTIBLE ACCOUNT EXPENSE: CREDIT SALES METHOD. Bradford ~Plumbing had the following data for a recent year. LO8 REQUIRED: 1. Compute uncollectible account expense for the year. 2....

Q:

(Appendices) UNCOLLECTIBLE ACCOUNT EXPENSE: AGING METHOD. Glencoe Supply had the following accounts receivable aging schedule at the end of a recent year: LO6