Computers and Technology, 14.04.2020 19:59, tyrone6410

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 a user tries to delete the last record (C777, Christina, A4, Mike) from CLIENT?
CLIENT
Client ID Client Name Client Agent Client Spouse Name
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
Agent ID Agent Name Agent Area Agent Rating Agent Year Of Hire Supervised
By
A1 Kate 1 101 1990
A2 Amy 2 92 2009 A1
A3 Luke 3 100 1992
A4 James 3 90 2010 A3
AREA
Area ID Area Name Area HQ
1 East Boston
2 West San Francisco
3 Central Chicago
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.

Answers: 2

Show answers

Other questions on the subject: Computers and Technology

Computers and Technology, 22.06.2019 05:10, kellysimkin6196

Read the code below. what will the computer print if the input for year_variable is 1700? if year_variable == 1776: print("your answer is correct. the declaration of independence was signed in “year_variable”.") elif year_variable < 1776: compute_variable = 1776 - year_variable. print("add “compute_variable“ years to your answer for the correct answer.") elif year_variable > 1776: compute_variable = year_variable - 1776 print("subtract “compute_variable” years from your answer for the correct answer.")

Answers: 1

continue

Computers and Technology, 22.06.2019 21:10, itsmichaelhere1

Dameas communication challenge is due to which factor

Answers: 2

continue

Computers and Technology, 23.06.2019 03:00, SKYBLUE1015

What are the different parts of computer

Answers: 2

continue

Computers and Technology, 23.06.2019 21:30, maddietomlinson113

Examine the list below. which factors positively affect lifetime income? check all that apply.