Consider the following AIRPLANE and FLIGHT relationship from the Grand Travel Airlines relational database. The left-hand...
Fantastic news! We've Found the answer you've been seeking!
Question:
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.
Expert Answer:
Related Book For
Fundamentals Of Database Systems
ISBN: 9780133970777
7th Edition
Authors: Ramez Elmasri, Shamkant Navathe
Posted Date:
Students also viewed these databases questions
-
Lee con atencin el siguiente prrafo y responde las preguntas que a continuacin se plantean: Luis y Blanca son amigos desde la secundaria y decidieron salir a comer para ponerse al da y pasar un...
-
The following data on air pollution in 41 U. S. cities are from Biometry (Sokal and Rohlf, 1981). The type of air pollution under study is the annual mean concentration of sulfur dioxide. The values...
-
The raw data for Problem 22, from Freund (1979), appear below. For the model of Problem 22, a. Fit the model. b. What discrepancies do you note between the results of (a) and the data summary...
-
There is a bond on the spot-market. Price is 87.63 USD. Risk-free interest rate is 1.22%. The forward-price is 102.78 USD. Is there any arbitrage possibility if time to maturity is 9 months?
-
MAX Corporation uses a process cost system. The company uses the FIFO method to account for inventory. The company began March with 3,000 units in WIP that were 70% complete. The company started...
-
Use the data in ATTEND.RAW for this exercise. (i) In the model of Example 6.3, argue that Use equation (6.19) to estimate the partial effect when priGPA = 2.59 and atndrte = 82. Interpret your...
-
The segment of the environment that refers to the other organizations with which an organization must interact in order to obtain inputs and dispose of outputs is called ____________. (a) the general...
-
According to an online survey by Harris Interactive for job site CareerBuilder.com (InformationWeek.com, September 27, 2007), more than half of IT workers say they have fallen asleep at work....
-
== Solve 5 cos(2x) = 3 for the smallest three positive solutions. x =
-
Finley Heaters Inc. is a mid sized manufacturer of residential water heaters. Sales have grown during the last several years, and the companys production capacity needs to be increased. The companys...
-
The objective of a diet problem is such that the quantities of certain foots that should be eaten to most certain nutritional requirements at a minimum cost. The consideration is limited to milk,...
-
A grain manufacturing company allocates the cost of unprocessed wheat to the production of feed, flour, and starch. For the current period, unprocessed wheat was purchased for $177,600, and the...
-
Salter Mining Company purchased the Northern Tier Mine for $ 6 7 million cash. The mine was estimated to contain 4 . 3 7 million tons of ore and to have a residual value of $ 6 million. During the...
-
Ray and Rachel are considering the purchase of two deluxe kitchen ovens. The first store offers the two ovens for $ 1 8 0 0 with payment due today. The second store offers the two ovens for $ 2 0 0 0...
-
How do HR leaders leverage sentiment analysis and employee feedback mechanisms to proactively identify and address potential organizational culture challenges or morale issues ?
-
Situation: A surf shop called Crazy Wave has seen sales drop after the euphoria of its opening. Since its inception, the owner has invested about $5,000 a month in traditional advertising (magazines,...
-
Greenwood Company manufactures two products-15,000 units of Product Y and 7,000 units of Product Z. The company uses a plantwide overhead rate based on direct labor-hours. It is considering...
-
Extend Algorithms 3.4 and 3.5 to include as output the first and second derivatives of the spline at the nodes.
-
What is the difference between the UNDO/REDO and the UNDO/NO REDO algorithms for recovery with immediate update? Develop the outline for an UNDO/NO-REDO algorithm.
-
Consider the EER design for the GRADE_BOOK database that was modeled using a tool like ERwin or Rational Rose in Laboratory Exercise 4.28. Using the SQL schema generation feature of the modeling...
-
Describe the main components of the IR system as shown in Figure 27.1. Figure 27.1 Document 3 Documont Document Corpus SEARCH INTENT Document 1 Information Need/Search Stopword removal Stemming...
-
Supreme Videos, Inc.. produces short musical videos for sale to retail outlets. The company's balance sheet accounts as of January 1. the beginning of its fiscal year, are given below. Required: 1....
-
Selected ledger accounts of Moore Company are given below for the just completed year: Raw Materials Manufacturing Overhead Bal. 1/1 Debits 15,000 Credits 120,000 110,000 Debits 230,000 Credits...
-
Why is activity-based costing growing in popularity?
Study smarter with the SolutionInn App