Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Draw a suitable ER diagram that models the following simplified airline-reservation sys- tem. An airline operates a number of services, each for a direct link

Draw a suitable ER diagram that models the following simplified airline-reservation sys- tem. An airline operates a number of services, each for a direct link from one airport (the origin) to another (the destination). Each service has a distinct code, a fixed departure and arrival time and a capacity (the total number of seats on the aircraft operating the service). Services need not operate daily: some operate only on certain days of the week, others may be seasonal and operate only for specifed periods. Customers have names (first and last), phone numbers and email addresses, as well as distinct customer num- bers. Customers may be booked on specific flights for a particular date. Each booking has a unique booking code and a number, reflecting the number of seats the customer has booked on the flight in question.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions