ComputerScienceExpert

(11)

$18/per page/

About ComputerScienceExpert

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Applied Sciences,Calculus See all
Applied Sciences,Calculus,Chemistry,Computer Science,Environmental science,Information Systems,Science Hide all
Teaching Since: Apr 2017
Last Sign in: 103 Weeks Ago, 4 Days Ago
Questions Answered: 4870
Tutorials Posted: 4863

Education

  • MBA IT, Mater in Science and Technology
    Devry
    Jul-1996 - Jul-2000

Experience

  • Professor
    Devry University
    Mar-2010 - Oct-2016

Category > Programming Posted 02 Jun 2017 My Price 8.00

HAPPY INSURANCE

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

Answers

ComputerScienceExpert
(11)
Status NEW Posted 02 Jun 2017 01:06 AM My Price 8.00

-----------

Not Rated(0)
Relevent Questions