irport_code City State Name DEPARTURE 1 AIRPORT N. Leg no AIRPORT Scheduled dep_time Scheduled arr_time FLIGHT_LEG M 1 ARRIVAL AIRPORT CAN LAND Instances LEGS N. Number Type name Max seats INSTANCE OF Airline FLIGHT ompany AIRPLANE ΤΥPE Ar_time Weekdays 1 DEPARTS ARRIVES Restrictions FARES N Dep_time Amount ΤΥPE N. Code FARE Airplane id Total_no_of_seats No of_avail_seats Date N ASSIGNED LEG INSTANCE AIRPLANE Customer_name Cphone Seat no RESERVATION N Notes: SEAT A LEG (segment) is a nonstop portion of a flig AIEO NCT ANG

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...
icon
Related questions
Question
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.
Airport code
City
State
Name
DEPARTURE
AIRPORT
N.
Leg no
--L --
AIRPORT
Scheduled_dep_time
Scheduled_arr_time
FLIGHT_LEG
M
N
ARRIVAL
AIRPORT
CAN
LAND
Instances
LEGS
N.
Number
Type name
Max seats
INSTANCE_OF
Airline
FLIGHT
Company
AIRPLANE
TYPE
Ar_time
Weekdays
1
DEPARTS
ARRIVES
Restrictions
FARES
N
Dep_time
N
Amount
N
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
N
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.
1
SEAT
Transcribed Image Text:Airport code City State Name DEPARTURE AIRPORT N. Leg no --L -- AIRPORT Scheduled_dep_time Scheduled_arr_time FLIGHT_LEG M N ARRIVAL AIRPORT CAN LAND Instances LEGS N. Number Type name Max seats INSTANCE_OF Airline FLIGHT Company AIRPLANE TYPE Ar_time Weekdays 1 DEPARTS ARRIVES Restrictions FARES N Dep_time N Amount N 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 N 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. 1 SEAT
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY