The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | May 2017 |
| Last Sign in: | 407 Weeks Ago, 5 Days Ago |
| Questions Answered: | 66690 |
| Tutorials Posted: | 66688 |
MCS,PHD
Argosy University/ Phoniex University/
Nov-2005 - Oct-2011
Professor
Phoniex University
Oct-2001 - Nov-2016
A company called FastCabs provides a taxi service to clients.
The table shown below displays some details of client bookings for taxis.
| JobID | JobDate | JobTime | DriverID | DriverName | TaxiID | ClientID | ClientName | JobPickUpAddress |
| 1 | 07/25/14 | 10.00 | D1 | Joe Bull | T1 | C1 | Anne Woo | 1 Storrie Rd, Paisley |
| 2 | 07/29/14 | 10.00 | D1 | Joe Bull | T1 | C1 | Anne Woo | 1 Storrie Rd, Paisley |
| 3 | 08/30/14 | 11.00 | D2 | Tom Win | T2 | C1 | Anne Woo | 3 High Street, Paisley |
| 4 | 08/2/14 | 13.00 | D3 | Jim Jones | T3 | C2 | Mark Tin | 1A Lady Lane, Paisley |
| 5 | 08/2/14 | 13.00 | D4 | Steven Win | T1 | C3 | John Seal | 22 Red Road, Paisley |
| 6 | 08/25/14 | 10.00 | D2 | Tom Win | T2 | C4 | Karen Bow | 17 High Street, Paisley |
Assume the table is complete, and will never change.
Assume that a taxi driver is assigned to a single taxi, but a taxi can be assigned to one or more drivers.
Identify the functional dependencies that exist between the columns of the table.
Identify the primary key.
Find any candidate keys (if present) for the table.
Hel-----------lo -----------Sir-----------/Ma-----------dam-----------Tha-----------nk -----------You----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------and----------- ac-----------qui-----------sit-----------ion----------- of----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n.P-----------lea-----------se -----------pin-----------g m-----------e o-----------n c-----------hat----------- I -----------am -----------onl-----------ine----------- or----------- in-----------box----------- me----------- a -----------mes-----------sag-----------e I----------- wi-----------ll