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$)$

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$ Consider the following relation with sample data.

SHIPMENTS TABLE

The SHIPMENTS Table for a car part company captures the data about car part shipments.

Each shipment has a unique Shipment ID and a Shipment Date.

Each shipment is shipped on one truck.

Each truck has a unique Truck ID and a Truck Type.

Each shipment can ship multiple products.

Each product has a unique Product ID and a Product Type.

Each quantity of a product shipped in a shipment is recorded in a table in the column Quantity.

E$4\mathrm{.}7$a Depict full key functional dependencies, partial functional dependencies $($if any$),$ and transitive functional

dependencies $($if any$),$ in the Shipments Table.

E$4\mathrm{.}7$b Show the result of normalizing the Shipments Table to $2$NF$.$

PLEASE DO QUESTION NUMBER $4$