Question 3: This case study concerns a flight reservation system for a travel agency. Interviews with business experts were conducted and their domain knowledge Was summarized in the following sentences: 1. Airlines offer flights. 2. A flight can be available for booking and can be closed by administrators. 3. A customer can book one or more flights, for different passengers. 4. A booking can be issued for one flight and one passenger. 5. A booking can be cancelled or confirmed. 6. A flight has one departure and one arrival airport. 7. A flight has a departure day and time, and an arrival day and time. 8. A flight may have stopovers at airports. 9. A stopover has an arrival time and a departure time. 10. Each airport serves one or more cities. Required Work: a) Draw the detailed class diagram of the above scenario by adding class names, attributes, methods and relationships between classes.
Question 3: This case study concerns a flight reservation system for a travel agency. Interviews with business experts were conducted and their domain knowledge Was summarized in the following sentences: 1. Airlines offer flights. 2. A flight can be available for booking and can be closed by administrators. 3. A customer can book one or more flights, for different passengers. 4. A booking can be issued for one flight and one passenger. 5. A booking can be cancelled or confirmed. 6. A flight has one departure and one arrival airport. 7. A flight has a departure day and time, and an arrival day and time. 8. A flight may have stopovers at airports. 9. A stopover has an arrival time and a departure time. 10. Each airport serves one or more cities. Required Work: a) Draw the detailed class diagram of the above scenario by adding class names, attributes, methods and relationships between classes.
Chapter1: Overview Of Database Concepts
Section: Chapter Questions
Problem 4RQ
Related questions
Question
100%
![Question 3:
This case study concerns a flight reservation system for a travel agency.
Interviews with business experts were conducted and their domain knowledge
Was summarized in the following sentences:
1. Airlines offer flights.
2. A flight can be available for booking and can be closed by administrators.
3. A customer can book one or more flights, for different passengers.
4. A booking can be issued for one flight and one passenger.
5. A booking can be cancelled or confirmed.
6. A flight has one departure and one arrival airport.
7. A flight has a departure day and time, and an arrival day and time.
8. A flight may have stopovers at airports.
9. A stopover has an arrival time and a departure time.
10. Each airport serves one or more cities.
Required Work:
a) Draw the detailed class diagram of the above scenario by adding class names, attributes,
methods and relationships between classes.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fefb3926d-a816-4971-85e9-1f0dbdf5436e%2Fdd7efc8e-fc82-40cd-bede-4bbb7613b270%2Fkdncdw8_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Question 3:
This case study concerns a flight reservation system for a travel agency.
Interviews with business experts were conducted and their domain knowledge
Was summarized in the following sentences:
1. Airlines offer flights.
2. A flight can be available for booking and can be closed by administrators.
3. A customer can book one or more flights, for different passengers.
4. A booking can be issued for one flight and one passenger.
5. A booking can be cancelled or confirmed.
6. A flight has one departure and one arrival airport.
7. A flight has a departure day and time, and an arrival day and time.
8. A flight may have stopovers at airports.
9. A stopover has an arrival time and a departure time.
10. Each airport serves one or more cities.
Required Work:
a) Draw the detailed class diagram of the above scenario by adding class names, attributes,
methods and relationships between classes.
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
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.Recommended textbooks for you
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)