Consider the following AIRPLANE and FLIGHT relationship from the Grand Travel Airlines relational database. The left-hand...

Transcribed Image Text:

Consider the following AIRPLANE and FLIGHT relationship from the Grand Travel Airlines relational database. The left-hand column of relative record numbers is there to facilitate answering some of the questions: # 1 2 3 4 # Airplane Number 04653 5 10582 6 16420 7 22663 1 005 Flight 2 018 Number Date 3 032 4 032 032 120 120 8 154 9 197 Manufacturer Boeing Airbus Canadair Boeing FLIGHT Time 11/15/2003 2:14PM 11/15/2003 9:03AM AIRPLANE Model 767 01/24/2004 7:52PM A320 01/28/2004 7:51PM CRJ 767 Departure Arrival Airplane Number Passenger Capacity Time 280 256 54 265 01/24/2004 11:00AM 1:32PM 10582 4:20PM 22663 11/16/2003 8:57:AM 10:23AM 16420 10:30AM 16420 11/17/2003 9:00AM 10:33AM 16420 9:34PM 16420 9:57PM 16420 11/15/2003 12:58PM 3:30PM 10582 02//12/2004 5:03PM 7:22PM 22663 Year Built 1988 1997 2001 1999 What would happen if the update rule between the Airplane and Flight tables is restrict, and an attempt is made to update the record #3 in Airplane Table by changing the value for Airplane Number from "16420" to "21420"? Please state the outcome and briefly explain the reason. Consider the following AIRPLANE and FLIGHT relationship from the Grand Travel Airlines relational database. The left-hand column of relative record numbers is there to facilitate answering some of the questions: # 1 2 3 4 # Airplane Number 04653 5 10582 6 16420 7 22663 1 005 Flight 2 018 Number Date 3 032 4 032 032 120 120 8 154 9 197 Manufacturer Boeing Airbus Canadair Boeing FLIGHT Time 11/15/2003 2:14PM 11/15/2003 9:03AM AIRPLANE Model 767 01/24/2004 7:52PM A320 01/28/2004 7:51PM CRJ 767 Departure Arrival Airplane Number Passenger Capacity Time 280 256 54 265 01/24/2004 11:00AM 1:32PM 10582 4:20PM 22663 11/16/2003 8:57:AM 10:23AM 16420 10:30AM 16420 11/17/2003 9:00AM 10:33AM 16420 9:34PM 16420 9:57PM 16420 11/15/2003 12:58PM 3:30PM 10582 02//12/2004 5:03PM 7:22PM 22663 Year Built 1988 1997 2001 1999 What would happen if the update rule between the Airplane and Flight tables is restrict, and an attempt is made to update the record #3 in Airplane Table by changing the value for Airplane Number from "16420" to "21420"? Please state the outcome and briefly explain the reason.