Mastering Database Management

0 of 78 lessons complete (0%)
Back to lesson

Lab Tutorial 2 Quiz

You don’t have access to this lesson

Please register or sign in to access the course content.

  1. 1. Retrieve the details of a reservation, including passenger and flight information.

    1
  2. 2. Find the total number of flights departing from each airport.

    1
  3. 3. List all flights with available seats for a specific date and destination airport.

    1
  4. 4. Find all passengers with reservations on a specific flight.

    1
  5. 5. Find all flights departing from a specific airport on a given date.

    1
  6. 6. List all reserved seats for a specific flight.

    1
  7. 7. Retrieve passenger information for a given reservation ID.

    1
  8. 8. Retrieve the total number of available seats for a specific flight.

    1
  9. 9. List all passengers who have not made any reservations.

    1
  10. 10. Retrieve the number of reservations made by a specific passenger.

    1