Given the following tables, what would be the resulting tables in 3NF? jobID jobDateTime driverlD driverName taxild clie

[answerhappygod]

Given The Following Tables What Would Be The Resulting Tables In 3nf Jobid Jobdatetime Driverld Drivername Taxild Clie 1 (56.61 KiB) Viewed 16 times

Given the following tables, what would be the resulting tables in 3NF? jobID jobDateTime driverlD driverName taxild client clientName job PickupAddress 1 25/07/20 10.00 D001 Joe Bull TO01 0001 Ali Shaman 5 Calverley St N 2 29/07/20 10.00 DO01 Joe Bull TO01 C001 Ali Shaman 5 Calverley St 3 30/07/20 11.00 DOO2 Tom Win TOO2 C001 Ali Shaman 10 Fish St 4 2/08/20 13.00 D003 Jim Jones T003 C002 Olio Tuti 17 Willow Terrace Rd 5 2/08/20 13.00 D004 Steven Win TO01 C003 James Purple 22 Cross York St 6 25/08/20 10.00 DOO2 Tom Win TOO2 C004 Fatihah Samat 36 Bridge St JobijobID, jobDateTime, driverlD, driverName, taxilD, clientID, clientName, job PickupAddress) Job(jobID, jobDateTime), JobPickup driver ID, client ID, taxild, job PickupAddress), Driver driver ID, driverName), Client(clientID, clientName) Job jobID, jobDateTime, driverlD, clientID, jobPickupAddress), Driver(driverID, driverName, taxilD), Client clientID, clientName) Job jobID, jobDateTime, job PickupAddress), Driver driverID, driverName, taxilD), Client(clientID, clientName)