HOMETOWN REALESTATEObserve the HOMETOWN REALESTATE database:…

HOMETOWN REALESTATEObserve the HOMETOWN REALESTATE database:SELLERSellerIDSellerNameRealtorIDS111PaulR1S222CarlyR1S333AnaR2S444CharlotteR2S555AidanR3C666EricR1C777ChristinaR1REALTORRealtorIDRealtorNameR1ClaireR2KateR3CliffR4WilliamThis database will be used for the following question 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 (R1, Claire) from REALTOR?

GENERICDATAObserve the tables GENERICDIMENSION1, GENERICDIME…

GENERICDATAObserve the tables GENERICDIMENSION1, GENERICDIMENSION2, and GENERICFACT:GENERICDIMENSION1AABBCCAA1BB1CC1AA2BB1CC1AA3BB2CC1AA4BB2CC1AA5BB3CC2GENERICDIMENSION2XXYYZZXX1YY1ZZ1XX2YY1ZZ2XX3YY2ZZ1XX4YY2ZZ2GENERICFACTAAXXNumberAA1XX1100AA1XX1100AA1XX3100AA1XX4100AA1XX4200AA1XX4200AA2XX4200AA3XX4200AA4XX1300AA5XX2300AA5XX2300AA5XX2300Assume the following hierarchy exist in the table GENERICDIMENSION1: CC –> BB –> AAAlso assume that there are no hierarchies in the table GENERICDIMENSION2.This scenario will be used for the questions citing GENERIC DATA.In the GENERIC DATA scenario below, ________ action was used to change Query A to Query B.QUERY A CC1CC2YY1500600YY21000300QUERY B BB1BB2BB3YY1200300600YY2800200300