Database - fpmi-pmvs2025/pmvs11a-lab8-flightwise GitHub Wiki

Entities

  • Airplanes (model, capacity)
  • Airports (unique code, name, city and country)
  • Flights (unites information about departure and arrival places and dates)
  • Users (authenticated users if the application)
  • Passengers (owners of tickets bought for certain flights, can be added by authenticated users)
  • Pricing rules (includes options of class or luggage availability)
  • Payments (activates the ticket, can be payed by authenticated user)
  • Tickets (unites information about passenger, flight and payment)

image

Tables

Airplanes

Airports

Flights

Users

Passengers

Pricing rules

Payments

Tickets

Relationships

Airplanes -> one to one -> Flights

Airports -> one to one -> Flights

Flights -> one to many -> Tickets

Tickets -> many to one -> Payments

Tickets -> one to one -> Passengers

Tickets -> many to one -> Pricing rules

Payments -> many to one -> Users