The Following Data Are in the Tables Employee (Primary Key

question 37

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) Row #7 of table Employee violates neither the entity integrity rule nor the referential integrity rule.
• B) Row #7 of table Employee violates the entity integrity rule.
• C) Row #7 of table Employee violates the referential integrity rule.
• D) Row #7 of table Employee violates both the entity integrity rule and the referential integrity rule.

Determine the impact of perfect complements and substitutes on consumer choice.

Identify the effects of normal and Giffen goods on consumption patterns.

Understand the substitution and income effects resulting from a change in price.

Apply the concept of a budget line to determine the possible consumption bundles given specific income and prices.

---

Definitions:

Master Control Relay Instruction

An alternate definition for MCR Instructions, specifically highlighting its role in controlling the execution flow in PLC programs.

Disconnect Switch

A Disconnect Switch is an electrical switch designed to completely cut off electrical power from part of a circuit or the entire system for safety or maintenance purposes.

Motor Starter Seal-In Contact

A contact in an electric motor starter circuit that maintains the circuit closed, keeping the motor running after the start button is released.

Programmed Contact

A virtual representation of a physical switch or condition used within PLC or relay logic to control the flow of a program.