Problem $1.$

BOSTransit, a transportation company, manages bookings for their shuttle service. The table below displays some details of client reservations for shuttles. Assume that a shuttle driver is assigned to a single shuttle, but a shuttle can be assigned to one or more drivers.

$($a$)$ Identify the functional dependencies represented by the attributes shown in the table below.

$($a$)$ Normalize the table in $3$NF normalized form.

Note: The answer should be in relations format, and you do not need to create a new table for the normalized relations. The table has been given to identify functional dependencies, prime and non$-$prime attribute types only.

$\backslash$table$[[\backslash$table$[[$Job$],[$ID$]],$Job Date$/$Time$,\backslash$table$[[$Driver$],[$ID$]],\backslash$table$[[$Driver$],[$Name$]],\backslash$table$[[$Taxi$],[$ID$]],\backslash$table$[[$Client$],[$ID$]],$Client Name,Job Pickup Address$],[101,\frac{25}{07}\frac{?}{1410}$:$00,$D$101,$Jane Smith,T$101,$C$201,$Chris Johnson,$5$ Main St$,$ Paisley$],[102,\frac{29}{07}\frac{?}{1410}$:$00,$D$101,$Jane Smith,T$101,$C$201,$Chris Johnson,$5$ Main St$,$ Paisley$],[103,\frac{30}{07}\frac{?}{1411}$:$00,$D$102,$John Doe,T$102,$C$201,$Chris Johnson,$8$ Elm St$,$ Paisley$],[104,\frac{2}{08}\frac{?}{1413}$:$00,$D$103,$Susan White,T$103,$C$202,$Mike Green,$10$ Oak Lane, Paisley$],[105,\frac{2}{08}\frac{?}{1413}$:$00,$D$104,$Kevin Black,T$101,$C$203,$Emily Young,$15$ Maple Rd$,$ Paisley$],[106,\frac{25}{08}\frac{?}{1410}$:$00,$D$102,$John Doe,T$102,$C$204,$Linda Grey,$20$ Cedar St$,$ Paisley$]]$