1. Consider the following ANIMAL and ENCLOSURE relations from the Central Zoo relational database. The left-hand column of relative record numbers is there to facilitate answering some of the questions. a. What would happen if the delete rule between the ENCLOSURE and ANIMAL relations is restrict and an attempt is made to delete the record for enclosure number 0912 in the ENCLOSURE relation? b. What would happen if the delete rule between the ENCLOSURE and ANIMAL relations is restrict and an attempt is made to delete the record for enclosure number 1660 in the ENCLOSURE relation? c. What would happen if the delete rule between the ENCLOSURE and ANIMAL relations is restrict and an attempt is made to delete the record for animal number 40436 in the ANIMAL relation? d. What would happen if the delete rule between the ENCLOSURE and ANIMAL relations is cascade and an attempt is made to delete the record for enclosure number 0912 in the ENCLOSURE relation? e. What would happen if the delete rule between the ENCLOSURE and ANIMAL relations is cascade and an attempt is made to delete the record for enclosure number 1660 in the ENCLOSURE relation? f. What would happen if the delete rule between the ENCLOSURE and ANIMAL relations is set-to-null and an attempt is made to delete the record for enclosure number 0912 in the ENCLOSURE relation? g. What would happen if the delete rule between the ENCLOSURE and ANIMAL relations is set-to-null and an attempt is made to delete the record for entlosure number 1660 in the ENCLOSURE relation? h. Using the SQL language described in Chapter 4, write SELECT statements to (Hint: Look back at Assignment \#5 at the information relational commands you wrote): i. Retrieve the record for animal number 58560. ii. Retrieve the record for the tiger named Stripes. iii. List all of the tigers born in India. iv. List the name and animal number of every animal born in China that weighs less than 100 pounds. v. List the name and number of every tiger. vi. What is the country of birth of animal number 74371 ? vii. What is the type and size of the enclosure used for animal number 74371 ? viii. List the name and address of every sponsor of animal number 74371