Solved

The Following Data Are in the Tables Employee (Primary Key

Question 32

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 Empno  Empname  Empdeptro  Empsalary  Emptitle 555 Keamy 2007000 manager 666 Williams 1008000 manager 777 Haberle 2005000 clerk 888 Haberle 2005000 clerk  Johnson 3004000 analyst 889 Dupont 400 McCabe 4006000 programmer 999 Lopez 9000 manager 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 Deptno  Deptname  Deptcity  Deptmgr 100 Logistics  Wichita 666200 Finance  Boise 555300 Marketing  Pierre 666Table~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}
-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:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Unlock this Answer For Free Now!

View this answer and more for free by performing one of the following actions

qr-code

Scan the QR code to install the App and get 2 free unlocks

upload documents

Unlock quizzes for free by uploading documents