C-AIR is a full-stack airline reservation web app built with Flask and Oracle DB. Supports flight search, seat-class booking, cancellation with tiered fees, and an admin statistics dashboard.

Database

Designed a 5-table schema (AIRPLANE, SEATS, CUSTOMER, RESERVE, CANCEL) with composite primary keys and UUID-based reservation IDs to support repeated reserve/cancel cycles on the same flight.

Features

Flight search with filters (airport, date, seat class, sort). Booking triggers a Gmail SMTP confirmation email. Cancellation fees are calculated automatically by days remaining until departure (₩150,000 → ₩180,000 → ₩250,000 → full price). Admin view exposes per-customer cancellation rates and payment rankings via RANK() window function.