Observe the HOMETOWN REALESTATE database: SELLER SellerID SellerName RealtorID S111 Paul R1 S222 Carly R1 S333 Ana R2 $444 Charlotte R2 S555 Aidan R3 Có66 Eric R1 C777 Christina R1 REALTOR RealtorID...


Observe the HOMETOWN REALESTATE database:<br>SELLER<br>SellerID<br>SellerName RealtorID<br>S111<br>Paul<br>R1<br>S222<br>Carly<br>R1<br>S333<br>Ana<br>R2<br>$444<br>Charlotte<br>R2<br>S555<br>Aidan<br>R3<br>Có66<br>Eric<br>R1<br>C777<br>Christina<br>R1<br>REALTOR<br>RealtorID RealtorName<br>R1<br>Claire<br>R2<br>Kate<br>R3<br>Cliff<br>R4<br>William<br>If a DBMS enforces a DELETE RESTRICT option on the referential integrity constraint between SELLER and REALTOR in the HOMETOWN REALESTATE database,<br>what will be the outcome after a user tries to delete the last record (R4, William) from REALTOR?<br>O SELLER will have 7 records, REALTOR wilIl have 4 records<br>O SELLER will have 6 records, REALTOR will have 3 records<br>O SELLER will have 7 records, REALTOR will have 3 records<br>O SELLER will have 6 records, REALTOR wilIl have 4 records<br>O SELLER will have 3 records, REALTOR willI have 3 records<br>

Extracted text: Observe the HOMETOWN REALESTATE database: SELLER SellerID SellerName RealtorID S111 Paul R1 S222 Carly R1 S333 Ana R2 $444 Charlotte R2 S555 Aidan R3 Có66 Eric R1 C777 Christina R1 REALTOR RealtorID RealtorName R1 Claire R2 Kate R3 Cliff R4 William If a DBMS enforces a DELETE RESTRICT option on the referential integrity constraint between SELLER and REALTOR in the HOMETOWN REALESTATE database, what will be the outcome after a user tries to delete the last record (R4, William) from REALTOR? O SELLER will have 7 records, REALTOR wilIl have 4 records O SELLER will have 6 records, REALTOR will have 3 records O SELLER will have 7 records, REALTOR will have 3 records O SELLER will have 6 records, REALTOR wilIl have 4 records O SELLER will have 3 records, REALTOR willI have 3 records

Jun 09, 2022
SOLUTION.PDF
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?