asked 227k views
0 votes
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 (a4, james, 3, 90, 2010, a3) from agent?

asked
User Koperko
by
7.6k points

1 Answer

2 votes
The answer is : CLIENT will have 7 records AGENT will have 4 records. If a dbms enforces a delete restrict option on the referential integrity constraint between client and agent in the happy insurance database, the outcome after a user tries to delete the last record (a4, james, 3, 90, 2010, a3) from agent is CLIENT will have 7 records AGENT will have 4 records.
answered
User Damien Locque
by
8.8k points
Welcome to Qamnty — a place to ask, share, and grow together. Join our community and get real answers from real people.