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.

Comprehend the concept of opportunity cost in different scenarios.

Differentiate between positive and normative statements.

Understand the construction and implications of economic models and the concept of economic policy.

Explain the role of scarce resources in economics and how they relate to the production possibilities curve.

---

Definitions:

Operating Leverage

A measure of how revenue growth translates into growth in operating income and the degree to which a company can increase operating income by increasing revenue.

Break-Even Point

The point at which total costs match total earnings from production or sales, leading to neither a profit nor a loss.

Maintenance Costs

The expenses incurred to keep an asset in working condition or restore it to proper operation.

Least-Squares Regression

A statistical method used to determine the line of best fit by minimizing the sum of the squares of the differences between observed values and those predicted by a linear function.