HAPPY INSURANCE
Observe the HAPPY INSURANCE DATABASE:
CLIENT AGENT AREA

question 9

Essay

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 l } \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 { A1 } \\\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.
-Assume a search form for HAPPY INSURANCE database is created where a user can perform the following action:
ENTER AREA ID:
ENTER AREA NAME:
ENTER AREA HQ:
ENTER AgentID:
ENTER AgentName:
ENTER AgentArea:
ENTER AgentRating:
ENTER AgentYearOfHire: 2010 (<--- Entered by the user)
ENTER SupervisedBY: A3 (<--- Entered by the user)
(User clicks on the search button upon entering the values above. )
Write the SQL statement that will be issued on the user's behalf based on this action.

---

Definitions:

Pleadings

Written statements filed with a court by parties to a legal dispute detailing their claims, defenses, and other legal arguments.

Notice

A formal communication informing someone of an action taken or to be taken, or a condition that affects legal rights or obligations.

Issues of Fact

Matters in a legal case that are subject to dispute between parties and are to be determined through the presentation of evidence.

In Rem Jurisdiction

A legal concept referring to the court's power to adjudicate matters pertaining to property within its territory, regardless of the owner's location.