2) Assume the Administrator and School relations contain the following data: (note primary keys are underlined while foreign keys are bold and italic)

Administrator

School

SchoolNumber	Name	Address	phoneNumber	built	size
45	Hogwarts School of Witchcraft and Wizardry	738 North Williams Ave.	5056448362	11/14/2000	414000
54	John Adams High School	8226 Selby Lane	5056444088	12/13/2012	118500
93	Bayside High	7914 Aspen Drive	5057756575	8/20/2000	175645
119	Dillon High School	475 South University Ave.	5058672818	10/3/2006	102598
345	Green Dale High	772 Grand St.	5056624410	9/17/2009	250345

Given a specific delete rule what would happen if the following commands were issued? Explain your answer. (60 points)

The delete rule is set to restrict. An attempt is made to delete the record for school number 45 from the school relation.

The delete rule is set to restrict. An attempt is made to delete the record for school number 345 from the school relation.

The delete rule is set to cascade. An attempt is made to delete the record for school number 119 from the school relation.

The delete rule is set to cascade. An attempt is made to delete the record for the administrator with an employee Id of 25.

The delete rule is set to set-to-null. An attempt is made to delete the record for school Number 54 from the school relation.

The delete rule is set to set-to-null. An attempt is made to delete the record for the administrator with an employee Id of 101.