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?

User Koperko
by
5.2k 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.
User Damien Locque
by
6.2k points