HOMETOWN REALESTATE

Observe the HOMETOWN REALESTATE database:

SELLER

SellerID

SellerName

RealtorID

S$111$

Paul

R$1$

S$222$

Carly

R$1$

S$333$

Ana

R$2$

S$444$

Charlotte

R$2$

S$555$

Aidan

R$3$

C$666$

Eric

R$1$

C$777$

Christina

R$1$

REALTOR

RealtorID

RealtorName

R$1$

Claire

R$2$

Kate

R$3$

Cliff

R$4$

William

If a DBMS enforces a DELETE SET$-$TO$-$NULL 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 first record $($R$1,$ Claire$)$ from REALTOR?

Group of answer choices

SELLER will have $7$ records, REALTOR will have $3$ records

SELLER will have $3$ records, REALTOR will have $3$ records

SELLER will have $6$ records, REALTOR will have $4$ records

SELLER will have $7$ records, REALTOR will have $4$ records

SELLER will have $6$ records, REALTOR will have $3$ records