Observe the HOMETOWN REALESTATE database: SELLER SellerID SellerName RealtorID S111 Paul R1 S222 Carly R1 S333 Ana R2 $444 Charlotte R2 S555 Aidan R3 C666 Eric R1 C777 Christina R1 REALTOR RealtorID RealtorName R1 Claire R2 Kate R3 Cliff R4 William If a DBMS enforces an UPDATE 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 update the RealtorID value in third record in table REALTOR from R3 to R5? O Value R5 appears once in column RealtorlD in REALTOR, and value R5 appears once in column RealtorID in table SELLER O Value R5 appears once in column RealtorID in REALTOR, and value R5 does not appear in column RealtorID in table SELLER O Value R5 does not appear in column RealtorID in REALTOR, and value R5 appears once in column RealtorID in table SELLER O Value R5 does not appear in column RealtorID in REALTOR, and value R5 does not appear in column RealtorID in table SELLER A) Value R5 appears once in column RealtorID in REALTOR, and value R5 appears twice in column RealtorID in table SELLER

5. Given the following Relations in a DBMS write the output of the queries, in tuple form with attribute labels. EMPLOYEE Fname Minit Lname Ssn Sex Salary Super_ssn Dno 123456789 1965-01-09 731 Fondren, Houston, TX M 30000 333445555 5 M 40000 888665555 J Zelaya 999887777 1968-01-19 3321 Castle, Spring, TX F 25000 987654321 F 43000 888665555 Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX M 38000 333445555 A English 453453453 1972-07-31 5631 Rice, Houston, TX F 25000 333445555 v Jabbar 987987987 1969-03-29 980 Dallas, Houston, TX M 25000 987654321 888665555 1937-11-10 450 Stone, Houston, TX M 55000 NULL Bdate Address John в Smith Franklin T Wong 333445555 1955-12-08 638 Voss, Houston, TX Alicia 4 Wallace 987654321 1941-06-20 291 Berry, Bellaire, TX Jennifer 4 Ramesh K Joyce 5 Ahmad 4 James E Borg DEPARTMENT DEPT LOCATIONS Dname Dnumber Mgr_ssn Mgr_start_date Dnumber Dlocation Research 5 333445555 1988-05-22 Houston Administration 4 987654321 1995-01-01 4 Stafford Headquarters…

Suppose that you are a manufacturer of product ABC, which is composed of parts A, B, and C. Each time a new product ABC is created, it must be added to the product inventory, using the PROD_QOH in a table named PRODUCT. Also, each time the product is created, the parts inventory, using PART_QOH in a table named PART, must be reduced by one each of parts A, B, and C. The sample database contents are shown in Table P10.1.Given the preceding information, answer Questions a through e.a. How many database requests can you identify for an inventory update for both PRODUCT and PART?b. Using SQL, write each database request you identified in Step a.c. Write the complete transaction(s).d. Write the transaction log, using Table 10.1 as your template.e. Using the transaction log you created in Step d, trace its use in database recovery.

Consider the following database instance. Table name: Students  Primary key: sid Sid sname 7 Ricky 2 Ellen 6 MaryLou 4 Ellen   Table name: Courses  Primary key: cid cid cname 1 ICS 2 Finance   Table name: Register Primary key: sid,cid Foreign key: sid references Students(sid) Foreign key: cid references Courses(cid) sid cid 7 2 2 2 7 1 4 1   5.1) For each of the following statements, show whether the statement is correctly executed or not (assume that the statements are executed in order, which means that if a statement is correctly executed, its effect is reflected in the following statement). If you say the statement is not executed, explain why. INSERT INTO Students VALUES (3, ‘Ellen’);     INSERT INTO Students VALUES (6, ‘Ellen’);     INSERT INTO Register VALUES (1, 2);     INSERT INTO Courses VALUES (5, ‘Systems’);     INSERT INTO Register VALUES (6, 5);     INSERT INTO Register…