Best writers. Best papers. Let professionals take care of your academic papers

Order a similar paper and get 15% discount on your first order with us
Use the following coupon "FIRST15"
ORDER NOW

HAPPY INSURANCE

/in /by

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 tables from the HAPPY INSURANCE database.

If a DBMS enforces an UPDATE RESTRICT 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?

Value A4 appears once in column AgentID in AGENT, and value A4 appears once in column ClientAgent in table CLIENT

Value A5 appears once in column AgentID in AGENT, and value A5 appears once in column ClientAgent in table CLIENT

Value A5 appears once in column AgentID in AGENT, and value A5 does not appear in column ClientAgent in table CLIENT

Value A5 does not appear in column AgentID in AGENT, and value A5 appears once in column ClientAgent in table CLIENT

 
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"