Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help with a program for an airplane flight planning system. Here are the following requirements Airport database: The system must contain a database

I need help with a program for an airplane flight planning system. Here are the following requirements

    1. Airport database:
      1. The system must contain a database of airport with the following information being stored in each
        1. ICAO Identifier: a three or four capital letter code identifying airport and navigational aid in the world uniquely, assigned by International Civil Aviation Organization.
        2. Name
        3. Latitude
        4. Longitude
        5. Communications radio frequencies: type and frequency
        6. Fuel types available: AVGAS for prop planes and / or JA-a for jets / turboprops
      2. The user must be able to add new airport
      3. The user must be able to modify any information about existing airports
      4. The user must be able to delete an airport
      5. The user must be able to display the information about an airport
    1. Airplane database
      1. The system must contain a database of airplanes with the following information being stored in each
        1. Make and model
        2. Type: Jet, Prop, and Turboprop
        3. Size of fuel tank in liters
        4. Fuel burn at cruise power setting in liters per hour
        5. Airspeed at cruise power setting in knots
      2. The user must be able to add new airplanes
      3. The user must be able to modify any information about existing airplanes
      4. The user must be able to delete an airplane
      5. The user must be able to display the information about an airplane
    2. Flight planning
      1. The user must be able to enter a type of airplane, a starting and one or more destination airports and have the system design an appropriate flight plan.
      2. The system must accept airport input in either ICAO format or as a substring of the full name. For instance, the airport in Columbia SC, the user can enter CAE or Columbia, SC. If more than one airport matches the substring entered, the system must display a menu of possible choices.
      3. The flight planning system must add refueling stops as destinations if the distance from the starting and destination airports is greater than the max range of the airplane chosen. The max range being determined by fuel burn rate, fuel tank capacity, and airspeed.
      4. The flight panning will include the following information for all legs
        1. Staring airport.
        2. Heading the true heading the pilot must fly to reach the destination
        3. Time to destination
        4. Distance of the leg
        5. Destination airport and COM frequencies.
      5. If the flight is impossible due to lack of refueling facilities, the program must report this.

I don't know where to start. Any help is appreciated.

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_2

Step: 3

blur-text-image_3

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

Database Concepts

Authors: David Kroenke, David Auer, Scott Vandenberg, Robert Yoder

9th Edition

0135188148, 978-0135188149, 9781642087611

More Books

Students also viewed these Databases questions

Question

What products or services does your key public commonly use?

Answered: 1 week ago

Question

What position do you seek?

Answered: 1 week ago