Follow the normalization process to normalize the above tables $($you need not show the

steps, but can use the blank sides of the exam if you want to work out the steps$)$ and show

the $3$NF relational schema for each resulting table in the following format:

$?$NF TABLENAME $($PRIMARY KEY, other attributes, FOREIGN KEY$($s$))$

Use appropriate names for all tables and attributes. Do not draw any dependency diagrams.

$(25$ points$)$

Use the above relational schemas to draw the Crow's Foot E$-$R Diagram $($include all

attributes, PKs$,$ and FKs$).(20$ points$).$ Thank you! This assignment is for information management.