HAPPY INSURANCE
Observe the HAPPY INSURANCE DATABASE:
CLIENT
ClientID ClientName ClientAgent
ClientSpouseName
C111 Tom A1
Jenny
C222 Karin A1
Bill
C333 Cole
A2 Amy
C444 Dorothy A2
C555 Andy A3
Amy
C666 Tina
A3 Matt
C777 Christina A4
Mike
AGENT
AgentID AgentName AgentArea AgentRating
AgentYearOfHire SupervisedBy
A1 Kate 1
101 1990
A2 Amy 2
92 2009 A1
A3 Luke 3
100 1992
A4 James 3
90 2010 A3
AREA
AreaID AreaName AreaHQ
1 East Boston
2 West San Francisco
3 Central Chicago
This database will be used for the following question citing
