Consider the ER diagram for the AIRLINE database shown in Figure 3.21. Build this design using a
Question:
Consider the ER diagram for the AIRLINE database shown in Figure 3.21. Build this design using a data modeling tool such as ERwin or Rational Rose.
Figure 3.21
Transcribed Image Text:
Airport_code City State Name DEPARTURE_ 1 AIRPORT N Leg no AIRPORT Scheduled_dep_time Scheduled_arr_time FLIGHT_LEG 1 ARRIVAL_ N CAN_ LAND AIRPORT Instances LEGS Number Type_name Max_seats INSTANCE_OF Company Airline FLIGHT N. Weekdays AIRPLANE_ Arr_time 1 TYPE DEPARTS> 1 ARRIVES Restrictions FARES 1 Dep_time N Amount TYPE Code FARE Airplane id Total_no_of_seats No_of_avail_seats N ASSIGNED LEG INSTANCE Date AIRPLANE Customer_name Cphone Seat no RESERVATION Notes: A LEG (segment) is a nonstop portion of a flight. A LEG_INSTANCE is a particular occurrence of a LEG on a particular date. SEAT
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 88% (9 reviews)
Each airport has an airport code and a name The airport code uniquely identifies an airport The city ...View the full answer
Answered By
Wilson Kariuki
Driven leveraging studies in Information Technology, Computer Programmer.
Offers strong interpersonal and task prioritization skills, Polytechnic University of the
Philippines 2018 - 2022, Cum Laude, President's List 1st and 2nd Semester 2021, President's List 1st and 2nd Semester 2020 , Dean's List 2018, 2019 and a SQL Database Developer at Information Technology Shanghai
0.00
0 Reviews
10+ Question Solved
Related Book For
Fundamentals Of Database Systems
ISBN: 9780133970777
7th Edition
Authors: Ramez Elmasri, Shamkant Navathe
Question Posted:
Students also viewed these Computer science questions
-
Consider the EER diagram for the UNIVERSITY database shown in Figure 4.9. Enter this design using a data modeling tool such as ERwin or Rational Rose. Make a list of the differences in notation...
-
Consider the ER diagram shown in Figure 7.21 for part of a BANK database. Each bank can have multiple branches, and each branch can have multiple accounts and loans. (a) List the strong (nonweak)...
-
Consider the ER diagram of Figure 5.5. State meaningful semantics for additional binary relationships among the entity types in the diagram and update the ER diagram accordingly with full...
-
The methyl alcohol flowing in the inner pipe of a double pipe exchanger is cooled with water flowing in the jacket. The inner pipe is made from 1-inch (25mm) schedule 40 steel pipe. The thermal...
-
Given the following trial balance and adjustment data for Lings Landscaping Service of Merritt, prepare a worksheet for the month of December. Adjustment Data a. Landscaping supplies on hand, $60 b....
-
As in all areas of IT, DBMSs are constantly changing and improving. Research how businesses are using DBMSs, and write a report of your findings. Address the following issues: 1. Which popular DBMS...
-
Which of the following would you expect to see at a company that espouses lean thinking? 1. Larger inventories 2. Smaller batch sizes 3. More organized workstations 4. Longer setup times 5....
-
Solve the following crossword. (Round your final answers to the nearest dollar, but do not round intermediate calculations.) ACROSS 1. A rich uncle has promised to pay you $3,160 a year for the next...
-
1. 2. 3. (c) 11 Let f : R R be a continuous function such that f(3x)-f(x) =. If f(8) = 7, then f(14) is equal to: (a) 4 (b) 10 (d) 16 Let O be the origin and A be the point z = 1 + 2i. If B is the...
-
Your co-worker wanted the afternoon off and you graciously agreed to finish up his work for him. Use the completed journal entries provided and post them to their T-accounts. Assume all accounts...
-
Define the following terms: superclass of a subclass, superclass/subclass relationship, IS-A relationship, specialization, generalization, category, specific (local) attributes, and specific...
-
Consider a MAIL_ORDER database in which employees take orders for parts from customers. The data requirements are summarized as follows: The mail order company has employees, each identified by a...
-
What health care services are not covered by Medicare?
-
What are the financial goals. List and explain also Create three SMART financial goals including the following: Savings Spending Sharing (Donating) For each goal, develop an action plan.
-
Differentiate the role of finance from other related disciplines such as accounting and economics. How finance is different from other discuss critically.
-
1. The following procedure evaluates the function z( x, y) where Z( x, y) = 27*x 14y+ (10*x + 17*y)* (19*x -3*y) procedure Evalz; var x, y, z: integer; begin write 'x? '; read x; write cr, lf, 'y? ';...
-
3. Ardro-electric plant discharging water at the rate of 0.75 m/sec and entering the turbine at 0.35 m/sec with pressure of 275 KPag has a runner of 55 cm internal diameter Speed ie 514 RPM at 260...
-
evaluate Write a code for a pseudorandom number generator in Python and use it to 5x/2 272 ln(2) cos(z)dr. 3/2 (You must program your own pseudorandom number generator and may not use any of Python's...
-
Changing the Damping Consider the mass-spring system + b + x = 0, x(0) = 4, (0) = 0. For damping coefficient b = 0, 0.5, 1, 2, 4, the corresponding solutions are plotted together in Fig. 4.3. 12 (a)...
-
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...
-
Consider the following relations for an order-processing application database at ABC, Inc. ORDER (O#, Odate, Cust#, Total_amount) ORDER-ITEM (O#, I#, Qty_ordered, Total_price, Discount%) Assume that...
-
Show that the relation schemas produced by Algorithm 15.4 are in 3NF.
-
Show that, if the matrix S resulting from Algorithm 15.3 does not have a row that is all "a" symbols, then projecting S on the decomposition and joining it back will always produce at least one...
-
Describe three tools to reduce to help reduce language barrier? Describe six barriers to communication using example of each. Describe three examples of verbal cues and three examples non-verbal...
-
Regarding a deal for widgets, X wants to buy them from Y but only if Z (an alternative widget maker) does not soon develop an improved widget design. Also, X wants flexibility about the amount. X...
-
What was the Great Recession? What is the gig economy? What are your thoughts? How does the gig economy impact unemployment?
Study smarter with the SolutionInn App