Database principles

Consider only the following four entities a. BRANCH Relation BRANCH NUM BRANCH NAME BRANCH LOCATION NUM EMPLOYEE b. BOOK TYPE Relationn TYPE DESCRIPTION c. BOOK Relation BOOK CODE TITLE PUBLISHER CODETYPE PRICE PAPERBACK d. INVENTORY Relation BOOK CODE BRANCH NU ON HAND Answer the following question. Use the database created in the assignment#5 using the sql file (henry bookstore modified.sql) and MySQL Workbench if needed and if you can. a. Explain what would happen if each of the following occurs Modify the database properly, write SOL commands to test your answers and submit the screenshots of the test results (a tutorial video will be provided to show how to modify the database) i. The delete rule between the BRANCH and INVENTORY relations is restrict and an attempt is made to delete the record for branch number 4 in the BRANCH relation. ii. The delete rule between the BRANCH and INVENTORY relations is cascade and an attempt is made to delete the record for branch number 4 in the BRANCH relation iii. The delete rule between the BOOK and INVENTORY relations is restrict and an attempt is made to delete the record for book code 0200' and branch number 1 in the INVENTORY relation. iiii. The delete rule between the BOOK and INVENTORY relations is cascade and an attempt is made to delete the record for book code "0200'and branch number 2 in the INVENTORY relation