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.
-Which of the following statements is true?
A) Rows #3 and #4 of table Employee, considered together, violate neither the entity integrity rule nor the referential integrity rule.
B) Rows #3 and #4 of table Employee, considered together, violate the entity integrity rule.
C) Rows #3 and #4 of table Employee, considered together, violate the referential integrity rule.
D) Rows #3 and #4 of table Employee, considered together, violate both the entity integrity rule and the referential integrity rule.
Correct Answer:
Verified