The Following Data Are in the Tables Employee (Primary Key

question 58

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

---

Definitions:

Monthly Dollar Sales

The total revenue generated from sales in a particular month measured in dollars.

Selling Price

The amount of money a customer pays to purchase a product or service.

Break-even

The point at which total costs and total income are equal, resulting in neither profit nor loss for a business.

Monthly Unit Sales

The total number of units sold in a given month.