QUESTION $34$

Given the data model shown below, please define the following:

$1)$ Table names

$2)$ Primary Keys for each table. If the key is composite, please indicate.

$3)$ Foreign Keys for each table and what table$/$field the FK relates to$.$

EMPLOYEE$($EmployeeNumber$,$ ELastName, EFirstName, EAddress, ECity, EZipCode, DepartCode$)$

DEPARTMENT$($DepartmentCode$,$ DeptName, DivisionCode$)$

DIVISION$($DivisionCode$,$ DivName, DivVP$)$

EPHONE$($PhoneID$,$ EmpNum, PhoneNumber, PhoneType$)$