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 03:00
How can i clip a picture to a question on the computer?
Answers: 1
Computers and Technology, 22.06.2019 11:00
Which action is good business etiquette? a. switching your cell phone off before you enter a meeting b. keeping your cell phone on low volume before you enter a meeting c. setting a pleasant ring tone on your cell phone before you enter a meeting d. setting a standard ringtone on your cell phone before you enter a meeting
Answers: 1
Computers and Technology, 22.06.2019 18:00
Which of the following physical laws can make the flow of water seem more realistic? a. motion b. gravity c. fluid dynamics d. thermodynamics
Answers: 2
Computers and Technology, 23.06.2019 09:10
Effective character encoding requires standardized code. compatible browsers. common languages. identical operating systems.
Answers: 1
If a DBMS enforces a DELETE RESTRICT option on the referential integrity constraint between CLIENT a...
Mathematics, 27.09.2020 14:01
Mathematics, 27.09.2020 14:01
Mathematics, 27.09.2020 14:01
English, 27.09.2020 14:01
Mathematics, 27.09.2020 14:01