Assignment $(60$ points$)$

Question E$3\mathrm{.}1$ through E$3\mathrm{.}3$ all parts $($page $982$nd Edition, page $891{?}^{st}$ Edition$)$

Question E$4\mathrm{.}1$ Through E$4\mathrm{.}4($pages ${1312}^{nd}$ Edition thru Page ${1201}^{st}$ Edition$)$

Given the Department of Transportation $($DOT$)$ project table $($below$)$ in exercise E$4\mathrm{.}7$ in

the chapter $4$ exercises and as well as the description of the data and business rules,

answer questions E$4\mathrm{.}7$a thru E$4\mathrm{.}7$c$.($page ${1332}^{nd}$ Edition, page ${1221}^{st}$ Edition$)$

$4...$Use the exercise E$4\mathrm{.}7($same as the above question$)$ table as well as explanation given,

try to identify entities in this single table. Draw the ERD, remove M$-$to$-$M relationship if

any, and write down conceptual files. What is your conclusion after this operation?

E$4\mathrm{.}7$ t pLEASE DO QUESTION NUMBER $4$ erd of the given question