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
Computers and Technology, 22.06.2019 09:00
Which best describes the condition under which the unicode output is the same as plain text?
Answers: 3
Computers and Technology, 22.06.2019 18:30
What is outfitting a workplace with video in a technology
Answers: 2
Computers and Technology, 23.06.2019 13:30
Me ! evelyn is a manager in a retail unit. she wants to prepare a report on the projected profit for the next year. which function can she use? a. pmt b. round c. division d. what-if analysis
Answers: 2
Computers and Technology, 23.06.2019 17:30
Write pseudocode to represent the logic of a program that allows the user to enter a value. the program multiplies the value by 10 and outputs the result.
Answers: 1
If a DBMS enforces a DELETE RESTRICT option on the referential integrity constraint between CLIENT a...
English, 08.10.2019 03:30
Chemistry, 08.10.2019 03:30
History, 08.10.2019 03:30
History, 08.10.2019 03:30
Biology, 08.10.2019 03:30
Mathematics, 08.10.2019 03:30
Mathematics, 08.10.2019 03:30
Social Studies, 08.10.2019 03:30
Mathematics, 08.10.2019 03:30
Computers and Technology, 08.10.2019 03:30