Question: Please answer questions 1 1 - 1 4 : HOMETOWN REALESTATE Observe the HOMETOWN REALESTATE database: SELLER SellerID SellerName RealtorID S 1 1 1 Paul
Please answer questions :
HOMETOWN REALESTATE
Observe the HOMETOWN REALESTATE database:
SELLER
SellerID
SellerName
RealtorID
S
Paul
R
S
Carly
R
S
Ana
R
S
Charlotte
R
S
Aidan
R
C
Eric
R
C
Christina
R
REALTOR
RealtorID
RealtorName
R
Claire
R
Kate
R
Cliff
R
William
This database will be used for the following questions citing tables from the HOMETOWN REALESTATE database:
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 first record R Claire from REALTOR?
Group of answer choices
SELLER will have records, REALTOR will have records
SELLER will have records, REALTOR will have records
SELLER will have records, REALTOR will have records
SELLER will have records, REALTOR will have records
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
