Question 3Consider the ER diagram below, which shows a simplified schema for an airline reservations system. Extract from the ER diagram the requirements and constraints that resulted in this schema. Try to be as precise as possible in your requirements and constraints specification. Question 3Consider the ER diagram below, which shows a simplified schema for an airline reservations system.Extract from the ER diagram the requirements and constraints that resulted in this schema. Try to be asprecise as possible in your requirements and constraints specification.Airport_codo City StateNameDEPARTUREAIRPORTNLeg noAIRPORTScheduled_dep_timoScheduled_arr_timeFLIGHT_LEGNCANLANDARRIVAL_AIRPORTInstancesLEGSNumberINSTANCE_OFAirlineN.Type name Max_seatsCompanyFLIGHTAIRPLANE_TYPEArr_timeWeekdaysDEPARTSARRIVESRestrictionsFARESOep_timeAmountТҮРECodeFAREN.Airplane idTotal_no_of_seatsNo of_avail seatsDateAIRPLANEASSIGNEDLEG INSTANCECustomer_nameCphoneSeat noRESERVATIONNotes:A LEG (segment) is a nonstop portion of a flight.A LEG INSTANCE is a particular occurrenceof a LEG on a particular date.SEAT

ER diagram describes the database structure that follows an Entity relationship model. From an ER…

Answered: Consider the ER diagram below, which…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

100%

Question 3

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