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.

Understand the social construction of race and ethnicity, and how these concepts differ across cultures and over time.

Explain the principle and effects of stereotype interchangeability and its application to various social groups.

Examine the complexity of ethnic classifications, such as Latino/Latina and Hispanic, and the problems arising from oversimplification.

Analyze historical acts of discrimination, such as the Chinese Exclusion Act, and their social and political contexts.

---

Definitions:

Payroll Register

A document listing each employee’s pay details for each payroll period, including wages, deductions, and net pay.

FICA Tax

Federal Insurance Contributions Act tax; a U.S. federal payroll tax that funds Social Security and Medicare.

Medicare Tax

A federal payroll tax that funds Medicare, the health insurance program for individuals aged 65 and over, as well as for some younger people with disability status as determined by the Social Security Administration.

Payroll Period

The interval of time for which an employee's wages are calculated, such as weekly, bi-weekly, or monthly.