Consider the Following AIRPLANE and FLIGHT Relations from the Grand

question 37

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.

---

Definitions:

Cross-Sectional

A research design that analyzes data from a population, or a representative subset, at a specific point in time.

Concrete Operations

A stage in Piaget's theory of cognitive development, typically occurring between ages 7 and 11, where children gain the ability to think logically about concrete events.

Formal Operations

The final stage in Piaget's theory of cognitive development, characterized by the ability to think abstractly, reason logically, and manage ideas in the mind without concrete manipulation.

Sensory-Motor

Referring to the processing of sensory information and motor response.