The Following Data Are in the Tables Employee (Primary Key

Multiple Choice

The following data are in the tables Employee (primary key: Empno) and Department (primary key: Deptno) . The questions refer to row numbers of this table. The first row of each table is row #1. Empdeptno in table Employee is a foreign key that refers to Deptno in the table Department. Deptmgr in the table Department is a foreign key that refers to Empno in the table Employee.
$Table~Employee\\\begin{array}{|l|l|l|l|l|}\hline \text { Empno } & \text { Empname } & \text { Empdeptro } & \text { Empsalary } & \text { Emptitle } \\\hline 555 & \text { Keamy } & 200 & 7000 & \text { manager } \\\hline 666 & \text { Williams } & 100 & 8000 & \text { manager } \\\hline 777 & \text { Haberle } & 200 & 5000 & \text { clerk } \\\hline 888 & \text { Haberle } & 200 & 5000 & \text { clerk } \\\hline & \text { Johnson } & 300 & 4000 & \text { analyst } \\\hline 889 & \text { Dupont } & 400 & & \\\hline & \text { McCabe } & 400 & 6000 & \text { programmer } \\\hline 999 & \text { Lopez } & & 9000 & \text { manager } \\\hline\end{array}$

$Table~Department\\\begin{array}{|l|l|l|l|}\hline \text { Deptno } & \text { Deptname } & \text { Deptcity } & \text { Deptmgr } \\\hline 100 & \text { Logistics } & \text { Wichita } & 666 \\\hline 200 & \text { Finance } & \text { Boise } & 555 \\\hline 300 & \text { Marketing } & \text { Pierre } & 666 \\\hline\end{array}$
-The values shown in the table Department:

A) violate neither the entity integrity rule nor the referential integrity rule
B) violate the entity integrity rule
C) violate the referential integrity rule
D) violates both the entity integrity rule and the referential integrity rule