HAPPY INSURANCE
Observe the HAPPY INSURANCE DATABASE:
CLIENT AGENT AREA

question 3

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.
-Show the CREATE TABLE statements for HAPPY INSURANCE database for the table CLIENT (assume that non-primary key columns can be optional)with the DELETE CASCADE option for its referential integrity constraint.

---

Definitions:

Straight-Line Depreciation

A depreciation technique that allocates an equal amount of depreciation each year over the asset's useful life.

Residual Value

The estimated amount that an asset is expected to sell for at the end of its useful life, subtracting any disposal costs.

Impairment Loss

A recognized reduction in the recoverable amount of an asset, indicating that its market value has dropped below its book value on the balance sheet.

Double-Declining-Balance

A method of accelerated depreciation which doubles the regular depreciation amount.