Relational database subject.

Question 20 Not yet answered Points out of 3.00 HAPPY INSURANCE Observe the HAPPY INSURANCE DATABASE CLIENT CientID C111 ? 222 C333 C444 C555 C666 C777 Flag question ClientName ClientAgent ClientSpouseWame A1 A1 A2 A2 ?? ?? A4 0m Kaim Cae Jenmy Bill Am Dorothy Andy Amy Matt Mike na Cristina AGENT AgentID AgentVame AgentArea AgentRating AgentYearOffHire SupervisedBy A1 A2 ?? A4 101 92 100 90 1990 2009 1992 2010 Kate 2 Amy Luke arnes ?? AREA ArealD AreaNameAreaHO East West Central Boston San Framcisco Chicago This database will be used for the following questions citing tables from the HAPPY INSURANCE database If a DBMS enforces a DELETE CASCADE option on the referential integrity constraint between CLIENT and AGENT in the HAPPY INSURANCE database, what will be the outcome after a user tries to delete the last record (A4, James, 3, 90, 2010, A3) from AGENT? Select one 0 a. CLIENT will have 6 records AGENT will have 3 records O b. CLIENT will have 6 records AGENT will have 4 records O C. CLIENT will have 7 records AGENT will have 4 records O d. CLIENT will have 7 records AGENT will have 3 records