Question: Consider the ER diagram in Figure 3.21, which shows a simplified schema for an airline reservations system. Extract from the ER diagram the requirements and

Consider the ER diagram in Figure 3.21, which shows a simplified schema for an airline reservations system. Extract from the ER diagram the requirements and constraints that produced this schema. Try to be as precise as possible in your requirements and constraints specification.

Figure 3.21

Airport code City Name State DEPARTURE_ AIRPORT Leg no AIRPORT Scheduled_dep_time Scheduled_arr_time

Airport code City Name State DEPARTURE_ AIRPORT Leg no AIRPORT Scheduled_dep_time Scheduled_arr_time FLIGHT LEG N M ARRIVAL_ CAN_ AIRPORT Instances LEGS LAND N. Number Type_nameMax_seats INSTANCE OF Company Airline FLIGHT AIRPLANE_ Arr_time Weekdays TYPE DEPARTS N ARRIVES Restrictions FARES Dep_time Amount TYPE N. Code FARE Airplane id Total_no_of_seats No of_avail_seats Date AIRPLANE ASSIGNED LEG INSTANCE 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 Figure 3.21 An ER diagram for an AIRLINE database schema.

Step by Step Solution

★★★★★

3.46 Rating (159 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

To extract requirements and constraints from the ER diagram of the airline reservations system we can detail each entity relationship and associated c... 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

Students Have Also Explored These Related Fundamentals Of Database Systems Questions!

Consider the ER diagram of Figure 7.20, which shows a simplified schema for an airline reservations system. Extract from the ER diagram the requirements and constraints that resulted in this schema....

Consider the ER diagram in Figure 7.22. Assume that an employee may work in up to two departments or may not be assigned to any department. Assume that each department must have one and may have up...

Consider the ER diagram in Figure 7.23. Assume that a course may or may not use a textbook, but that a text by definition is a book that is used in some course. A course may not use more than five...

Module 3 Exercise 3 . 1 8 : Show an alternative design for the attribute described below, that uses only entity types ( including weak entity types, if needed ) and relationship types. {...

HW2 Chapter 3 Due at 11:59 pm, Friday, 2/8/2019 1. (50 points) Consider the ER diagram of Figure 1, which shows a simplified schema for an airline reservations system. 1) Extract from the ER diagram...

Q 2. Solve question 7.32 from textbook - Consider the ER diagram of Figure 7.29, which shows a simplified schema for an airline reservations system. Extract from the ER diagram the requirements and...

Problem 2 (20 Points): Consider the ER diagram of Figure 1, which shows a part of a BANK database. Extract from the ER diagram the requirements and constraints that resulted in this schema. Try to be...

Consider the ER diagram in Figure 3.21 in your textbook (Shown Below), which shows a simplified schema for an airline reservations system. Extract from the ER diagram the requirements and constraints...

Submit Relational Model of ER diagram of Figure 7.29 in the Book (Q2 from Week 4 Lab) Q 2. Solve question 7.32 from textbook - Consider the ER diagram of Figure 7.29, which shows a simplified schema...

Part 2- Consider the ER diagram of the below figure, which shows a simplified schema for an airline reservations system. Extract from the ER diagram the requirements and constraints that resulted in...

Read this hypo for Torts and answer only IF THE ELEMENT of the scope of the duty was met. This is for Louisiana Civil Law Torts. Once you read the hypo, fill in the skeleton below to answer if the...

What is measured in FAME analyses?

The National Security Agency s ( NSA s ) Infosec Assessment Methodology ( IAM ) is a good example of a qualitative risk - assessment methodology. As such, which of the following statements is least...

From what you now know about the nature of groups, what do you think the responsibilities of the person who chairs the meeting are?

In SQL, specify the following queries on the database specified in Figure 3.5 using the concept of nested queries and the concepts described in this chapter. a. Retrieve the names of all employees...

Show the result of each of the sample queries in Section 6.5 as it would apply to the database state in Figure 3.6.

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

I want to know how is g= 0.085 Please explain me Value line shows that Honda Motor pays a dividend of 0.90 I in 2009 and they increase to 1.15 in expected 2011 - 2013. Then we can interpolate the...

Need Help Please Belief in Haunted Places A random sample of 285 college students were asked if they believed that places could be haunted, and 112 responded yes. Estimate the true proportion of...

A project your firm is considering requires an investment today of $ 5 8 , 0 0 0 and is forecasted to generate a cash flows starting one year from today of $ 5 9 6 2 per year forever. If the...