HAPPY INSURANCE

Observe the HAPPY INSURANCE DATABASE:
CLIENT AGENT

question 41

Multiple Choice

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 { Matt } \\\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 a DELETE SET-TO-NULL option on the referential integrity constraint between CLIENT and AGENT in the HAPPY INSURANCE database,what will be the outcome after aUser tries to delete the last record (A4,James,3,90,2010,A3) from AGENT?

• A)CLIENT will have 7 records
• AGENT will have 4 records
• B)CLIENT will have 6 records
• AGENT will have 3 records
• C)CLIENT will have 7 records
• AGENT will have 3 records
• D)CLIENT will have 6 records
• AGENT will have 4 records

---

Definitions:

Civil Rights Act

Landmark legislation in the United States that outlaws discrimination based on race, color, religion, sex, or national origin, primarily known for its application during the 1960s civil rights movement.

Discrimination

The unjust or prejudicial treatment of different categories of people or things, especially on the grounds of race, age, or sex.

Disparate-Impact

Refers to practices in employment, housing, or other areas that adversely affect one group of people more than another, even if unintentional.

Protected Class

Groups of people legally protected from discrimination on the basis of characteristics such as race, religion, national origin, gender, and more.