HAPPY INSURANCE
Observe the HAPPY INSURANCE DATABASE:
CLIENT AGENT AREA

question 39

True/False

HAPPY INSURANCE
Observe the HAPPY INSURANCE DATABASE:
CLIENT

$$\begin{array} { l l c l } \text { ClientID } & \text { ClientName } & \text { CientAgent } & \text { ClientSpouseName } \\\text { C111 } & \text { Tom } & \text { A1 } & \text { Jenny } \\\text { C222 } & \text { Kain } & A 1 & \text { Bill } \\\text { C333 } & \text { Cole } & A 2 & \text { Amy } \\\text { C444 } & \text { Dorothy } & A 2 & \\\text { C555 } & \text { Anay } & A 3 & \text { Amy } \\\text { C666 } & \text { Tina } & A 3 & \text { Madt } \\\text { C777 } & \text { Christina } & A 4 & \text { Mike }\end{array}$$ AGENT
$$\begin{array} { l l l l l c } \text { AgentID } & \text { AgentName } & \text { AgentArea } & \text { AgentRating } & \text { AgentYearofHire } & \text { SupervisedBy } \\\text { A1 } & \text { Kate } & 1 & 101 & 1990 & \\\text { A2 } & \text { Amy } & 2 & 92 & 2009 & \text { Al } \\\text { A3 } & \text { Luke } & 3 & 100 & 1992 & \\\text { A4 } & \text { James } & 3 & 90 & 2010 & \text { A3 }\end{array}$$ AREA
$$\begin{array} { l l l } \text { ArealD } & \text { AreaName } & \text { AreaHQ } \\1 & \text { East } & \text { Boston } \\2 & \text { West } & \text { San Francisco } \\3 & \text { Central } & \text { Chicago }\end{array}$$

This database will be used for the following questions citing tables from the HAPPY INSURANCE database.
-If a DBMS enforces in the HAPPY INSURANCE database an UPDATE RESTRICT option on the referential integrity constraint between AGENT and AGENT (i.e. ,circular referential integrity constraint for table AGENT)in the HAPPY INSURANCE database,and an UPDATE CASCADE between AGENT and CLIENT,value A1 in the first record in the table AGENT can be changed to A5.

---

Definitions:

Level Of Significance

The threshold used in statistical tests to decide whether an observed effect is considered statistically significant.

P-Value

A statistical metric that helps you determine the significance of your research results, essentially telling you how likely your data would have occurred by random chance.

One-Tail Test

A statistical test where the region of rejection is on only one side of the sampling distribution, used when the research hypothesis predicts a direction of the effect.

Two-Tailed Test

A hypothesis testing approach that allows for the possibility of an effect in two directions, either higher or lower than the null hypothesis, and hence tests for the presence of any significant difference.