1. 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 3NF relational...

1. 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) andshow the 3NF relational schema for each resulting tablein 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.

2.Use the above relational schemas to draw the Crow’s Foot E-R Diagram (include all attributes, PKs, and FKs).