The Following Data Are in the Tables Employee (Primary Key

question 69

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

---

Definitions:

Accounting Method

A set of rules used to determine when and how income and expenses are reported in the financial statements.

Business Segment

A distinct part of a company that can be separated for analyzing its financial performance, often by product line or geographical location.

Independent Auditor's Report

A document provided by an independent auditor as a result of an audit or evaluation of a company's financial statements, giving an opinion on the financial statements' accuracy and compliance with accounting standards.

Financial Statements

Formal records of the financial activities and position of a business, individual, or other entity, typically including the balance sheet, income statement, and cash flow statement.