(5) Consider the ER diagram shown below, which shöWS schema for an airline reservations system. Extract from the ER diagram the requirements (Entities, attributes, relationships, keys) and constraints that produced this schema. Be as precise as possible in your requirements and constraints specification.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question
100%
(5) Consider the ER diagram shown below, which shows a simplified
schema for an airline reservations system. Extract from the ER diagram
the requirements (Entities, attributes, relationships, keys) and
constraints that produced this schema. Be as precise as possible in
your requirements and constraints specification.
Airport code
City
State
Name
DEPARTURE
AIRPORT
Leg no
AIRPORT
Scheduled_dep_time
Scheduled_arr_time
FLIGHT LEG
N
M
ARRIVAL
AIRPORT
CAN
Instances
LEGS
LAND
Number
Type name
Max_seats
INSTANCE_OF
Company
Airline
FLIGHT
N.
AIRPLANE_
ΤΥΡE
Arr time
Weekdays
DEPARTS
KARRIVES
Restrictions
FARES
N
Dep_time
Amount
ΤΥPE
Code
FARE
Airplane_id
Total no_of_seats
No of avail_seats
ASSIGNED
LEG_INSTANCE
Qate
AIRPLANE
Customer_name
Cphone
Seat no
RESERVATION
Notes:
1
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
Transcribed Image Text:(5) Consider the ER diagram shown below, which shows a simplified schema for an airline reservations system. Extract from the ER diagram the requirements (Entities, attributes, relationships, keys) and constraints that produced this schema. Be as precise as possible in your requirements and constraints specification. Airport code City State Name DEPARTURE AIRPORT Leg no AIRPORT Scheduled_dep_time Scheduled_arr_time FLIGHT LEG N M ARRIVAL AIRPORT CAN Instances LEGS LAND Number Type name Max_seats INSTANCE_OF Company Airline FLIGHT N. AIRPLANE_ ΤΥΡE Arr time Weekdays DEPARTS KARRIVES Restrictions FARES N Dep_time Amount ΤΥPE Code FARE Airplane_id Total no_of_seats No of avail_seats ASSIGNED LEG_INSTANCE Qate AIRPLANE Customer_name Cphone Seat no RESERVATION Notes: 1 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
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 4 images

Blurred answer
Knowledge Booster
Database Environment
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education