$($P$\mathrm{.}1)$ For each table, identify the primary key and the foreign key$($S$).$ If a table does not have a foreign key, write None to indicate no FK $($P$\mathrm{.}2)$ Do the...

$($P$\mathrm{.}1)$ For each table, identify the primary key and the foreign key$($s$).$ If a table does not have a foreign key, write None to indicate no FK

$($P$\mathrm{.}2)$ Do the tables exhibit entity integrity? For each table answer yes or no and then explain your answer

$($P$\mathrm{.}3)$ Do the tables exhibit referential integrity? For each table answer yes or no and then explain your answer. Write NA $($Not Applicable$)$ if the table does not have a foreign key.