Complete all problems, thank you P$3\mathrm{.}1$ THE CH$03\_$STORECO DATABASE TABLES

Table name: EMPLOYEE

Database name: Ch$03\_$StoreCo

Table name: STORE

Table name: REGION

$1.$ For each table, identify the primary key and the foreign key$($s$).$ If a table does not

have a foreign key, write None.

$2.$ Do the tables exhibit entity integrity? Answer yes or no$,$ and then explain your answer.

$3.$ 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.

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

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

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

$7.$ Describe the type$($s$)$ of relationship$($s$)$ between EMPLOYEE and STORE.

$($Hint: Each store employs many employees, one of whom manages the store.$)$

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

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

REGION.