SL SkyLedger Flight search, booking, and order control
Passenger Sign In

CS307 Project 1 · Task 4

Operate the airline database through a single web console.

Generate ticket inventory for a date range, search routes with optional time filters, complete bookings, and manage passenger orders without touching SQL by hand.

Search Tickets Sign In to Book

Current Database Snapshot

  • Flight templates21764
  • Flight instances108820
  • Inventory rows217640
  • Passengers1000
  • Active orders90057
  • Available dates2026-02-01 → 2026-02-05

Requirement 1

Generate Tickets by Date Range

This action derives fresh flight_instance rows from the existing flight templates, then seeds both cabin inventories using the latest known fare template for each route.

Workflow

Passenger-Facing Flow

  1. Search tickets by departure city, arrival city, and date.
  2. Refine results with airline, departure-after, or arrival-before filters.
  3. Sign in with passenger name and mobile number.
  4. Book economy or business cabin and create a live order record.
  5. Cancel booked orders or delete cancelled ones from the order center.