A company called FastCabs provides a taxi service to clients. The table shown in figure displays some details of client bookings for taxis. Assume that a taxi driver is assigned to a single taxi, but a taxi can be assigned to one or more drivers.

(1) Identify the functional dependencies that exist between the columns of the table and identify the primary key and any alternative key(s) (if present) for the table.

(2) Apply normalization to 3NF on the table. Please identify the primary key and foreign key for each table after normalization.

Transcribed Image Text:

TaxilD ClientID JobPickUpAddress 1 Storrie Rd, Paisley 1 Storrie Rd, Paisley 3 High Street, Paisley IA Lady Lane, Paisley 22 Red Road, Paisley 17 High Street, Paisley JobDate Time ID 25/07/14 10.00 JobID ClientName Driver Driver Name Anne Woo Anne Woo Anne Woo Mark Tin DI 29/07/14 10.00 TI Joe Bull TI Joe Bull Tom Win DI 30/07/14 11.00 2/08/14 13.00 2/08/14 13.00 25/08/14 10.00 D2 T2 Jim Jones ТЗ TI Steven Win T2 C2 C3 D3 John Seal Karen Bow D4 6. Tom Win D2 C4 TaxilD ClientID JobPickUpAddress 1 Storrie Rd, Paisley 1 Storrie Rd, Paisley 3 High Street, Paisley IA Lady Lane, Paisley 22 Red Road, Paisley 17 High Street, Paisley JobDate Time ID 25/07/14 10.00 JobID ClientName Driver Driver Name Anne Woo Anne Woo Anne Woo Mark Tin DI 29/07/14 10.00 TI Joe Bull TI Joe Bull Tom Win DI 30/07/14 11.00 2/08/14 13.00 2/08/14 13.00 25/08/14 10.00 D2 T2 Jim Jones ТЗ TI Steven Win T2 C2 C3 D3 John Seal Karen Bow D4 6. Tom Win D2 C4

Answer rating: 100% (QA)

1 The following is a functional dependency that exists between the displayed columns of the table Jo... View the full answer