Use the Storeco database shown below to answer problems $1,2,3,4,3,6,7,8,$ and $9.$

Table name: EMPLOYEE

Database name: StoreCo

Table name: STORE

Table name: REGION

For each table, identify the primary key and the foreign key$($s$).$ If a table does not have a foreign key, write None$\mathrm{.}1.$ Do the tables exhibit entity integrity? Answer yes or no$,$ and then explain your answer.

$2.$ Do the tables exhibit referential integrity? Answer yes or no$,$ and then explain your answer. Write NA $($Not Applicable$)$ if the table does not have a foreign key.

$3.$ Describe the type$($s$)$ of relationship$($s$)$ between STORE and REGION.

$4.$ Create the ERD to show the relationship between STORE and REGION.

$5.$ Create the relational diagram to show the relationship between STORE and REGION.

$6.$ Describe the type$($s$)$ of relationship$($s$)$ between EMPLOYEE and STORE. $($Hint: Each store employs many employees, one of whom manages the store.$)$

$7.$ Create the ERD to show the relationships among EMPLOYEE, STORE, and REGION.

$8.$ Create the relational diagram to show the relationships among EMPLOYEE, STORE, and REGION.