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 c } \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 { Al } \\ \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. -If a DBMS enforces a DELETE SET-TO-NULL option on the referential integrity constraint between CLIENT and AGENT in the HAPPY INSURANCE database,what will be the outcome after aUser tries to delete the last record (A4,James,3,90,2010,A3)from AGENT?

A) CLIENT will have 7 records AGENT will have 4 records B) CLIENT will have 6 records AGENT will have 3 records C) CLIENT will have 7 records AGENT will have 3 records D) CLIENT will have 6 records AGENT will have 4 records A) CLIENT will have 7 records AGENT will have 4 records B) CLIENT will have 6 records AGENT will have 3 records C) CLIENT will have 7 records AGENT will have 3 records D) CLIENT will have 6 records AGENT will have 4 records

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 c } \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 { Al } \\ \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. -If a DBMS enforces a DELETE RESTRICT option on the referential integrity constraint between CLIENT and AGENT in the HAPPY INSURANCE database,what will be the outcome after aUser tries to delete the last record (A4,James,3,90,2010,A3)from AGENT?

A) CLIENT will have 7 records AGENT will have 4 records B) CLIENT will have 6 records AGENT will have 3 records C) CLIENT will have 7 records AGENT will have 3 records D) CLIENT will have 6 records AGENT will have 4 records A) CLIENT will have 7 records AGENT will have 4 records B) CLIENT will have 6 records AGENT will have 3 records C) CLIENT will have 7 records AGENT will have 3 records D) CLIENT will have 6 records AGENT will have 4 records

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 c } \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 { Al } \\ \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. -If a DBMS enforces an UPDATE 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 change the AgentID value in the last record to A5?

A) Value A4 appears once in column AgentID in AGENT,and value A4 appears once in column ClientAgent in table CLIENT B) Value A5 appears once in column AgentID in AGENT,and value A5 appears once in column ClientAgent in table CLIENT C) Value A5 appears once in column AgentID in AGENT,and value A5 does not appear in column ClientAgent in table CLIENT D) Value A5 does not appear in column AgentID in AGENT,and value A5 appears once in column ClientAgent in table CLIENT A) Value A4 appears once in column AgentID in AGENT,and value A4 appears once in column ClientAgent in table CLIENT B) Value A5 appears once in column AgentID in AGENT,and value A5 appears once in column ClientAgent in table CLIENT C) Value A5 appears once in column AgentID in AGENT,and value A5 does not appear in column ClientAgent in table CLIENT D) Value A5 does not appear in column AgentID in AGENT,and value A5 appears once in column ClientAgent in table CLIENT

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 SET-TO-NULL and UPDATE CASCADE option for its referential integrity constraint.

CREATE TABLE client (clientid CHAR(4), c

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 AGENT (assume that non-primary key columns can be optional)with the user defined constraint specifying that the agent rating must be between 50 and 150.

6CREATE TABLE agent (agentid CHAR(2), ag

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 c } \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 { Al } \\ \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. -If a DBMS enforces a DELETE SET-TO-DEFAULT 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?

A) CLIENT will have 7 records AGENT will have 4 records B) CLIENT will have 6 records AGENT will have 3 records C) CLIENT will have 7 records AGENT will have 3 records D) CLIENT will have 6 records AGENT will have 4 records A) CLIENT will have 7 records AGENT will have 4 records B) CLIENT will have 6 records AGENT will have 3 records C) CLIENT will have 7 records AGENT will have 3 records D) CLIENT will have 6 records AGENT will have 4 records

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 c } \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 { Al } \\ \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. -If a DBMS enforces a DELETE CASCADE option on the referential integrity constraint betweenCLIENT and AGENT in the HAPPY INSURANCE database,what will be the outcome after aUser tries to delete the last record (A4,James,3,90,2010,A3)from AGENT?

A) CLIENT will have 7 records AGENT will have 4 records B) CLIENT will have 6 records AGENT will have 3 records C) CLIENT will have 7 records AGENT will have 3 records D) CLIENT will have 6 records AGENT will have 4 records A) CLIENT will have 7 records AGENT will have 4 records B) CLIENT will have 6 records AGENT will have 3 records C) CLIENT will have 7 records AGENT will have 3 records D) CLIENT will have 6 records AGENT will have 4 records