3. Consider the following requirements of a database for airline flight information system. a. Each flight...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
3. Consider the following requirements of a database for airline flight information system. a. Each flight is identified by a flight number, the weekdays it operates on, and consists of one or more flight legs. A flight leg is a nonstop portion of a flight. b. Each flight leg of a particular flight is identified by a number 1, 2, 3, etc., its scheduled arrival and departure times and arrival and departure airports. The flight leg is associated with many instances of that leg one for each date on which the flight travels. The leg number is unique for flight legs of the same flight. Each instance of the flight leg is recorded, along with the airplane used, and the actual arrival and departure times. Fares are kept for each flight. Each fare has a type (business, economy, charter, a price associated with each fare type for each flight leg. C. d. Each airport has code (unique), name, (unique), and city. ), and e. Airplanes have different types that are identified by their name (e.g. Boeing, Airbus, etc.), the manufacturer, and the number of seats on board for each fare type. Different airports only allow certain airplane types to land. f. Each airplane has a number that is unique for airplanes of the same type, an airplane type, technical status (in service, out of service, maintenance, etc.) Design a database for the airline information system described above. (15 points) 3. Consider the following requirements of a database for airline flight information system. a. Each flight is identified by a flight number, the weekdays it operates on, and consists of one or more flight legs. A flight leg is a nonstop portion of a flight. b. Each flight leg of a particular flight is identified by a number 1, 2, 3, etc., its scheduled arrival and departure times and arrival and departure airports. The flight leg is associated with many instances of that leg one for each date on which the flight travels. The leg number is unique for flight legs of the same flight. Each instance of the flight leg is recorded, along with the airplane used, and the actual arrival and departure times. Fares are kept for each flight. Each fare has a type (business, economy, charter, a price associated with each fare type for each flight leg. C. d. Each airport has code (unique), name, (unique), and city. ), and e. Airplanes have different types that are identified by their name (e.g. Boeing, Airbus, etc.), the manufacturer, and the number of seats on board for each fare type. Different airports only allow certain airplane types to land. f. Each airplane has a number that is unique for airplanes of the same type, an airplane type, technical status (in service, out of service, maintenance, etc.) Design a database for the airline information system described above. (15 points)
Expert Answer:
Related Book For
Fundamentals of Database Systems
ISBN: 978-0136086208
6th edition
Authors: Ramez Elmasri, Shamkant Navathe
Posted Date:
Students also viewed these programming questions
-
Specify queries a, b, c, and d of Exercise 8.17 in both tuple and domain relational calculus. Exercise 8.17 Consider the AIRLINE relational database schema shown in Figure 5.8, which was described in...
-
Consider the AIRLINE relational database schema shown in Figure 3.8, which describes a database for airline flight information. Each FLIGHT is identified by a flight NUMBER, and consists of one or...
-
The following coefficients define a Fourier series ao = b an == || HI2 bn = 1 2 - sin(n/2) for n1 NA sin[(n 1)/2] 1-n {sin((1 + sin[(n+1)/2]] 1+n /]} for n 2. (1) (2) (3) (4) (a) Using Matlab,...
-
Sound is passing perpendicularly through an open window whose dimensions are 1.1 m 0.75 m. The sound intensity level is 95 dB above the threshold of hearing. How much sound energy comes through the...
-
For the year ending December 31, 2012, Sanjay Company accumulates the following data for the plastics division, which it operates as an investment centre: contribution margin -$700,000 budgeted,...
-
What levels of an organization benefit most from a data warehouse?
-
Melissa Adduci has prepared the following list of statements about depreciation. 1. Depreciation is a process of asset valuation, not cost allocation. 2. Depreciation provides for the proper matching...
-
Provide an example of a Cross Site Scripting (XSS) attack. Include an explanation of the differences between stored and reflective XSS attacks. 2). Provide an example of a SQL Injection attack. Why...
-
Which of these is hydrophobic? Glucose 00 K+ CI Water Fat QUESTION 54 The coiling and folding of a polypeptide chain into a more circular molecule is the primary secondary tertiary quaternary 0000...
-
During COVID, the government provided low-income families with a child tax credit. That policy had a major impact on child poverty in the United States. Now that the credit is going away, child...
-
Mrs Kebede S, consumes two good A and B, when Ke bede,s income increase from birr 4000 to 5000, the quantity of good A demanded by increase Kebede e by 35%. What conclusion do you draw from this.
-
es Determine the ending balance of each of the following T-accounts. Accounts Payable Cash 140 90 2,400 340 100 3,300 60 540 10 Supplies 10,400 1,500 4,200 9,200 Accounts Receivable 800 190 190 190...
-
IBM Corporation was the leading manufacturer of electronic computers in the world. Based on its internal memoranda, IBM's long-run total cost of producing various quantities of its Pisces (370/168)...
-
How do collaborative efforts between governments and non-governmental organizations (NGOs) influence policy-making on a global scale ? explain
-
Accounting taxation question (5) Same information as in Q4. From 1 February 2019 onwards, Mr. Mason failed to pay the rent and left the property on 31 March 2019. After searching Mr. Mason for a few...
-
SCHEDULE OF COST OF GOODS MANUFACTURED The following information is supplied for Sanchez Welding and Manufacturing Company. Prepare a schedule of cost of goods manufactured for the year ended...
-
Suppose that a file initially contains r=120,000 records of R=200 bytes each in an unsorted (heap) file. The block size B=2400 bytes, the average seek time s=16 ms, the average rotational latency...
-
Consider a STUDENT relation in a UNIVERSITY database with the following attributes (Name, SSN, Local_phone, Address, Cell_phone, Age, GPA). Note that the cell phone may be from a different city and...
-
Consider the following six relations for an order-processing database application in a company: CUSTOMER (Cust#, Cname, City) ORDER (Order#, Odate, Cust#, Ord_Amt) ORDER_ITEM (Order#, Item#, Qty)...
-
The period of free vibrations of a nonlinear system depends upon initial conditions. Indicate whether the statement presented is true or false. If true, state why. If false, rewrite the statement to...
-
A spring has a cubic nonlinearity which is an example of a (geometric, material) _______________________________ nonlinearity.
-
Period doubling is a route to chaos. Indicate whether the statement presented is true or false. If true, state why. If false, rewrite the statement to make it true.
Study smarter with the SolutionInn App