Concept explainers
Use the below description of a Flight Reservation System (FRS) to answer the following questions.
The Flight reservation system is a part of the customer/passenger service system where the application will support the customer the improve efficiency. This will reserve the specified airline and also interface with its global distribution system and helps the travel agencies to make reservations. this system's scope is to utilize the capacity of the flight and reduce the manual errors involved at reservation. this system will hold the details about,
- Flight schedule
- customer reservation
- ticket data
- fare tariffs
This system solves the problems including:
- seat reservation details
- seat allocation errors
- error in seat number
- mishandling of the data
The objective of the system are:
- this will make sure the user(prompt) allocate the airline ticket
- repeated works will be minimized
- the flight capacity is utilized in a better manner, by handling the vacant seats.
- this system contains
- reservation
- booking
- rescheduling
- canceling
this system helps in reducing the stressful process and saves time and enhances to prevent the short comings which are associated along with the manual to prevent the rush.
- Proposed a suitable methodology for the scenario?
- Construct the UML models of the above scenario. Use stereotype in the Use case and class Diagram?
Step by stepSolved in 2 steps
- Attracted by the success of Spotify, a group of students want to build their own music-streaming website called Musicmatic. Being economists, they are unaware of the specificities of databases and have therefore asked you to create an EER model. A large number of songs will be made available through their website, and the following information on each song needs to be stored: title, year, length, and genre. Also, artist information will be added, including date of birth, name, and a URL to a website (e.g., Wikipedia page) with additional information on the artist. You can assume an artist is uniquely identified by her name, and that a song always belongs to exactly one artist. The Musicmatic students also point out that songs having the same title are possible, and only the combination of song and artist can be assumed to be unique. The database will also have to store information on the people using Musicmatic. It was decided to only discriminate between two types of users: regular…arrow_forwardSelect all of the situations related to network configuration. A coffee shop chain is trying to decide whether to open a new location a few blocks away from another one of their locations. O A major retailer is trying to decide how many of its trucks to send between warehouses. A company is trying to decide whether to select a supplier in Canada or in England. O A distributor is trying to find the most efficient way of delivering products from their warehouses to customer facilities.arrow_forwardConsider a conceptual schema given below. LONGER TSERVICE SHORTER TSERVICE total-days total-hours DRIVER TSERVICE dlnumber enumber first-name last-name phone[e..] ID1 ID2 BUS departure-city destination-city departure-time arrival time ID ID ID Assigned-to - - Assigned-to date-when-assigned ID rego make 1..* snumber Passes-through 0..1 date-when-discharged STOP stop-City edap larrival-time Your task is to perform a step of logical database design, i.e. to transform a conceptual schema given above into a collection of relational schemas. For each relational schema clearly list the names of attributes, primary key, candidate keys (if any), and foreign keys (if any). Assume, that a superset method must be used to implement a generalization. T0arrow_forward
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education