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

Another question on Computers and Technology

Computers and Technology, 23.06.2019 03:00

Your business be in google top rank.more the rank more the business leads.for best seo and digital marketing services be confident to contact you can get best seo solutions by assistance experts provide digital marketing, website development, seo expert services and social media internet seo expert services your branding solutions. seo expert services ,best seo expert services,online seo expert services,

Answers: 3

Answer

Computers and Technology, 23.06.2019 06:00

When is a chart legend used a. all the time b. whenever you are comparing data that is the same c. whenever you are comparing multiple sets of data d. only for hand-drawn charts

Answers: 2

Answer

Computers and Technology, 23.06.2019 09:30

Light travels at a speed of 186,000 miles a second. the distance light travels in a year is 5,865,690,000,000 miles/year 5,865,695,000,000 miles/year 58,656,950,000,000 miles/year 6,789,000,0000 miles/year

Answers: 1

Answer

Computers and Technology, 23.06.2019 22:00

Take a critical look at three gui applications you have used—for example, a spreadsheet, a word-processing program, and a game. describe how well each conforms to the gui design guidelines listed in this chapter.

Answers: 3

Answer

You know the right answer?

If a DBMS enforces a DELETE RESTRICT option on the referential integrity constraint between CLIENT a...

Questions