E$4\mathrm{.}6$ Consider the following relation with sample data.

DEPARTMENT OF TRANSPORTATION $($DOT$)$ PROJECT TABLE

$\backslash$table$[[$ProjectID$,$ProjectName,CountyID,CountyName,ProjectManagerID,ProjectManagerName,ProjectMilesWithinCounty$],[1,$Road X$,1,$Wilson,M$1,$Bob,$10\mathrm{.}00],[1,$Road X$,2,$Ottawa,M$1,$Bob,$17\mathrm{.}00],[1,$Road X$,3,$Davis,M$1,$Bob,$12\mathrm{.}00],[2,$Road Y$,3,$Davis,M$2,$Sue,$23\mathrm{.}00],[3,$Bridge A$,1,$Wilson,M$3,$Lee,$0\mathrm{.}50],[3,$Bridge A$,2,$Ottawa,M$3,$Bob,$0\mathrm{.}30],[4,$Tunnel Q$,2,$Ottawa,M$1,$B$4,2\mathrm{.}00],[5,$Road W$,4,$Pony,Mob,$23\mathrm{.}00,]]$

The DEPARTMENT OF TRANSPORTATION $($DOT$)$ Project Table captures the data about projects and their length $($in miles$).$

Each project has a unique Project ID and Project Name.

Each county has a unique County ID and County Name.

Each project manager has a unique Project Manager ID and Project Manager Name.