Observe the HAPPY INSURANCE DATABASE:
CLIENT
ClientID ClientName ClientAgent...
Computers and Technology, 17.04.2020 20:58 kymberlyasher
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 a DELETE SET-TO-DEFAULT 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 (A4, James, 3, 90, 2010, A3) from AGENT?
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
Another question on Computers and Technology
Computers and Technology, 22.06.2019 08:50
Can online classes such as gradpoint track your ip location like if im taking a final and i give somebody else my account and they take the final for me will it show where they are taking the final from? and can this be countered with a vpn
Answers: 1
Computers and Technology, 22.06.2019 17:00
Annie is creating a corporate report for a company’s annual meeting. in the report, she wants to add the signature of various department heads. which device can annie use to capture signatures to include in the report? a. printer b. monitor c. e-reader d. digitizing tablet
Answers: 1
Computers and Technology, 23.06.2019 23:40
Which of the following calculates the total from the adjacent cell through the first nonnumeric cell by default, using the sum function in its formula? -average -autosum -counta -max
Answers: 1
Computers and Technology, 24.06.2019 07:30
Aproject involves many computing systems working together on disjointed task towards a single goal what form of computing would the project be using
Answers: 3
You know the right answer?
Questions
Mathematics, 29.04.2021 08:10
Computers and Technology, 29.04.2021 08:10
Mathematics, 29.04.2021 08:10
Arts, 29.04.2021 08:10
Chemistry, 29.04.2021 08:10
Mathematics, 29.04.2021 08:10
Chemistry, 29.04.2021 08:10
Mathematics, 29.04.2021 08:10
