Consider the Following AIRPLANE and FLIGHT Relations from the Grand

Essay

Consider the following AIRPLANE and FLIGHT relations from the Grand Travel Airlines relational database. The left-hand column of relative record numbers is there to facilitate answering some of the questions:
$\begin{array}{ll}&\text { Airplane } \quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad \text { Passenger Year }\\&\text { Number\quad Manufacturer\quad Model\quad Capacity\quad Built }\\\begin{array}{lr}1\\2\\3\\4\end{array}&\begin{array}{|r|l|l|r|r|}\hline 04653\quad & \text { Boeing }\quad\quad & 767\quad\quad & 280\quad & 1988\quad \\\hline 10582 & \text { Airbus } & \text { A320 } & 256 & 1997 \\\hline 16420 & \text { Canadair } & \text { CRJ } & 54 & 2001 \\\hline 22663 & \text { Boeing } & 767 & 265 & 1999 \\\hline\end{array}\end{array}$
Airplane relation
$\begin{array}{lr}&\text { Flight } \quad\quad\quad\quad\quad\quad\quad \text { Departure }\quad \text { Arrival }\quad \text { Airplane } \\&\text { Number }\quad \text { Date }\quad\quad\quad \text { Time }\quad\quad\quad \text { Time \quad\quad} \text { Number }\\\begin{array}{lr}1\\2\\3\\4\\5\\6\\7\\8\\9\end{array}&\begin{array}{|r|r|r|r|r|}\hline 005 \quad& 11 / 15 / 2003 & 2: 14 \mathrm{PM} & 4: 20 \mathrm{PM} & 22663 \\\hline 018 & 01 / 24 / 2004 & 11: 00 \mathrm{AM} & 1: 32 \mathrm{PM} & 10582 \\\hline 032 & 11 / 15 / 2003 & 9: 03 \mathrm{AM} & 10: 30 \mathrm{AM} & 16420 \\\hline 032 & 11 / 16 / 2003 & 8: 57: \mathrm{AM} & 10: 23 \mathrm{AM} & 16420 \\\hline 032 & 11 / 17 / 2003 & 9: 00 \mathrm{AM} & 10: 33 \mathrm{AM} & 16420 \\\hline 120 & 01 / 24 / 2004 & 7: 52 \mathrm{PM} & 9: 34 \mathrm{PM} & 16420 \\\hline 120 & 01 / 28 / 2004 & 7: 51 \mathrm{PM} & 9: 57 \mathrm{PM} & 16420 \\\hline 154 & 11 / 15 / 2003 & 12: 58 \mathrm{PM} & 3: 30 \mathrm{PM} & 10582 \\\hline 197 & 02 / / 12 / 2004 & 5: 03 \mathrm{PM} & 7: 22 \mathrm{PM} & 22663 \\\hline\end{array}\end{array}$ Flight relation
a. What would happen if the delete rule between the AIRPLANE and FLIGHT relations is restrict and an attempt is made to delete the record for airplane number 16420 in the AIRPLANE relation?
b. What would happen if the delete rule between the AIRPLANE and FLIGHT relations is restrict and an attempt is made to delete the record for airplane number 04653 in the AIRPLANE relation?
c. What would happen if the delete rule between the AIRPLANE and FLIGHT relations is restrict and an attempt is made to delete the record for flight number 120 on 01/24/2004 in the FLIGHT relation?
d. What would happen if the delete rule between the AIRPLANE and FLIGHT relations is cascade and an attempt is made to delete the record for airplane number 16420 in the AIRPLANE relation?
e. What would happen if the delete rule between the AIRPLANE and FLIGHT relations is cascade and an attempt is made to delete the record for airplane number 04653 in the AIRPLANE relation?
f. Record 3 in the AIRPLANE relation would be deleted and the Airplane Number values of records 3, 4, 5, 6, and 7 in the FLIGHT relation would be updated to null.
g. Record 1 in the AIRPLANE relation would be deleted.