Question: Observe the Happy Insurance database below: CLIENT ClientID ClientName AgentID Client SpouseName ClientIncome CHI Tom 47 Jenny 102,000 C222 Karin 4 Bill 105,000 C333 Cole
Observe the Happy Insurance database below: CLIENT ClientID ClientName AgentID Client SpouseName ClientIncome CHI Tom 47 Jenny 102,000 C222 Karin 4 Bill 105,000 C333 Cole 42 Amy 80,000 C444 Dorothy 42 90,000 C555 Andy 43 70,000 C666 Tina Mall 180,000 C777 Christina AS Mike 200,000 AGENT AgentID AgentName AgentArea Agent Rating Agent Year Ofire Supervised By AgentSalary Kate 101 1990 102.000 42 Amy 2 92 2009 41 100,000 Luke 2 100 1992 101.000 44 James 3 90 2010 43 90.000 45 Salcedo 3 100 2018 41 80,000 AREA ArealD AreaName Areall 1 East Boston West San Francisco 3 Central Chicago + South Memphis 4a) Draw the relational schema for the Happy Insurance database 4b) Draw the ER Diagram for the Happy Insurance database
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
