Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

An airline has an algorithm to determine the priority of passengers who are wait-listed for a flight. It calculates a priority key based upon (1)

image text in transcribed

image text in transcribed

image text in transcribed

An airline has an algorithm to determine the priority of passengers who are wait-listed for a flight. It calculates a priority key based upon (1) frequent flyer status, (2) price paid for the ticket and (3) arrival time at the gate. The lower the key value, the higher placed the passenger is in the queue. The calculation is as follows: -If frequent flyer status is 'NONE', add 40 to priority key. If frequent flyer status is 'SLVR', add 30 to priority key. If frequent flyer status is 'GOLD', add 20 to priority key. If frequent flyer status is 'PLAT', do not add anything to priority key -If price paid for the ticket is $500 or more, do not add anything to the priority key. Otherwise points are accumulated for every drop in price. Each price range is $49. For every drop between $1 and $49 dollars, add 5 to the priority key. For example, if the ticket price was $310, add 20 points to the priority key. - The gate is considered to be open 1 hour prior to the flight. If the passenger is 60 minutes early, no points are added. For each minute closer to the flight time, add 1 point to the priority key Example

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Fundamentals Of Database Systems

Authors: Sham Navathe,Ramez Elmasri

5th Edition

B01FGJTE0Q, 978-0805317558

More Books

Students also viewed these Databases questions

Question

When do courts grant specific performance as a remedy?

Answered: 1 week ago