Answered: an Air is the national airline of Oman…

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

See similar textbooks

Related questions

Concept explainers

Question

Oman Air is the national airline of Oman and was founded in June 1993. Oman Air wants to upgrade its information system. Oman Air's fleet consists of many airplanes. The proposed system should keep track airplane serial, model, class (economy, business, and first class), and the capacity of seats from each class. Each airplane has many flights. For each flight, the system should keep track of flight serial, flight type (international or domestic), planned departure date and time, planned arrival date and time, actual departure date and time, actual arrival date and time, ticket price in OMR for adult, child, and infant passengers, and travel insurance in OMR. As you know, each country has many airports, so the proposed system should keep track of source airport, and destination airport for each flight. Each flight has many seat categories such as (choice, paid choice, extra legroom (exit seat), premium, galley, lavatory, etc.). Each seat category has its own price. So the system should keep track of seat category, and seat category price in OMR. A passenger should pay more above the ticket price if he/she needs to book a specific seat. Each passenger has title (Mr., Mrs., Miss, etc.), name, date of birth, gender (male, or female) mobile, mobile number of one of the relatives, E-mail address, nationality, passport number, passport issue and expire dates. The system should keep track for each passenger booking reference number, seat number, and may also record male preference (bland, diabetic, fruit platter, low calorie, low fat, low salt, seafood, vegetarian, etc.) and special service (blind passenger, hearing impaired, wheelchair, etc.) if a passenger wants to specify them. Also the system should keep track payment details such as card number, card expire date, and card verification code. Booking a ticket implies checking passenger’s card balance and its validity, so the system should record the date of purchasing a ticket. Cancelling a reservation implies a request from a passenger to refund ticket price, so the system should record the request date to refund ticket price. A passenger can search for different flights between source and destination in different days to know ticket price, book, cancel, modify, and search for his/her ticket by booking reference number. For the above case study, and using Sybase Power Designer S/W, or one of the open source S/W that supports UML (such as draw.io, click chart, star UML, etc.) draw the following diagrammatic techniques: 1. A conceptual data model (ERD), or a class diagram.

Expert Solution

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Business Intelligence Analytics tools and techniques

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