The chart in the PDF file shows an E$-$R diagram.

Each box in the diagram has been created as a table with the primary key $($PK$)$ and attributes $($data fields$)$ as shown in the diagram.

$1.(50$pts$)$ For the five boxes without a primary key shown, select an appropriate primary key compatible with $3$NF$.$ That is$,$ the key should uniquely determine each record, only the key should uniquely determine each record, and there should be no transitive dependencies in the table.

$2.(50$pts$)$ Suppose that the field Staff.Zip determines the two fields Staff.City and Staff.State. How would you split the Staff table into two tables following $3$NF$?$

$3.(50$pts$)$ For the Manager table, suppose that some of the fields track historical as well as current data. Manager.Performance is quarterly, Manager.CarAllowance is annual, and Manager.Monthly bonus is monthly. How would you split the Manager table into a set of tables following $3$NF$?$A Simple Entity Relationship Diagram for a Restaurant System.