Here is a database called HAPPY INSURANCE.

Base all of your answers for questions $4-8$ on this database:

Observe the HAPPY INSURANCE DB:

Client

ClientID ClientName ClientAgent ClientSpouseName

C$111$ Tom A$1$ Jenny

C$222$ Karin A$1$ Bill

C$333$ Cole A$2$ Amy

C$444$ Dorothy A$2$

C$555$ Andy A$3$ Amy

C$666$ Tina A$3$ Matt

C$777$ Christina A$4$ Mike

Agent

AgentID AgentName AgentArea AgentRating AgentYearOfHire SupervisedBy

A$1$ Kate $11011990$

A$2$ Amy $2922009$ A$1$

A$3$ Luke $31001992$

A$4$ James $3902010$ A$3$

Area

AreaID AreaName AreaHQ

$1$ East Boston

$2$ West San Francisco

$3$ Central Chicago