Question: 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

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 more FLIGHT_LEGs with LEG_NUMBERs 1, 2, 3, etc. Each leg has scheduled arrival and departure times and airports, and has many LEG_INSTANCEs--one for each DATE on which the flight travels. FARES are kept for each flight. For each leg instance, SEAT_RESERVATIONs are kept, as is the AIRPLANE used in the leg, and the actual arrival and departure times and airports. An AIRPLANE is identified by an AIRPLANE_ID, and is of a particular AIRPLANE_TYPE. CAN_LAND relates AIRPLANE_TYPEs to the AIRPORTs in which they can land. An AIRPORT is identified by an AIRPORT_CODE. Consider an update for the AIRLINE database to enter a reservation on a particular flight or flight leg on a given date.
(a) Give the operations for this update.
(b) What types of constraints would you expect to check?
(c) Which of these constraints are key, entity integrity, and referential integrity constraints and which are not?
(d) Specify all the referential integrity constraints on Figure 3.8.

Step by Step Solution

★★★★★

3.45 Rating (155 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a One possible set of operations for the following update is the following INSERT into SEATRESERVATI... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

888-CS-DB (2274).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

Assume that RMO will begin by asking a random sample of customers who order by telephone about purchases made from competitors. RMO will give customers a 15 percent discount on their current order in...

Assume that RMO will begin asking a random sample of customers who order by telephone about purchases made from competitors. RMO will give customers a 15 percent discount on their current order in...

Specify the following queries on the COMPANY relational database schema shown in Figure 3.5, using the relational operators discussed in this chapter. Also show the result of each query as it would...

5.12 Database Consider the AIRLINE relational database schema shown in Figure 5.8, which describes a database for airline flight information. Each FLIGHT is identified by a Flight_number, and...

Consider the AIRLINE relational database schema shown in Figure 5.8, which describes a database for airline flight information. Each FLIGHT is identified by a Flight_number, and consists of one or...

5.12. Consider the AIRLINE relational database schema shown in Figure 5.8, which describes a database for airline flight information. Each FLIGHT is identified by a Flight_number, and consists of one...

Question 3 : Consider the AIRLINE relational database schema shown in Figure 1 , which describes a database for airline flight information. Each FLIGHT is identified by a Flight _ number, and...

5 points] Adapted from 5.16-Consider the following relations for a database that keeps track of student enrollment in courses and the books adopted for each course: STUDENT (SSN, Name, Major, Bdate)...

A) Consider the following relations for a database that keeps track of student enrollment in courses and the books adopted for each course: STUDENT (SSN, Name, Major, Bdate) COURSE (Course#, Quarter,...

Homework Assignment # 2 : Textbook Exercise 8 . 1 7 ( page 2 8 2 , in 7 th Edition ) Note: You only do Exercise 8 . 1 7 for this homework assignment # 2 . 8 . 1 7 Consider the AIRLINE relational...

The arithmetic test of the NAEP (National Assessment of Education Progress) survey was applied to a sample of 1,077 women between 21 and 25 years old. The average of their results was 275 points....

Use the method of matched leading behaviors to graph the following Hill functions (Chapter 2, Equation 2.6.1) and their variants. 1. 2. 3. 4. hs) 1+x (x)= 10+ x3 hi (x)s 1x1010 ho) 10 810(x) = 0.14x10

Exercise 10-6A (Static) Determining net present value LO 10-2 Aaron Heath is seeking part-time employment while he attends school. He is considering purchasing technical equipment that will enable...

Look at the activities from two projects that produced similar deliverables. Describe the quality of the deliverables in terms of project team activities.

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 Airport_code City State Name DEPARTURE_...

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...

Given the ER schema for the MOVIES database in Figure 3.25, draw an instance diagram using three movies that have been released recently. Draw instances of each entity type: MOVIES, ACTORS,...

The owner of an antique store estimates that there is a 35% chance she will make $2400 when she sells an antique chinacabinet, a 60% chance she will make $900 when she sells thecabinet, and a 5%...

1 . What would be the impact on the company s financial statement if PolyMedica had expensed the costs as incurred in 2 0 0 3 and 2 0 0 2 ? Calculate key balances that highlight any major differences...

ACTUARIAL solution please A stock pays annual dividends at the end of each year. The earnings per share in the year just ended were $102. Earnings are assumed to grow at 7.3% per year in the future....