This case describes a real-world scenario based on a fictional new commuter airline seeking to develop a database to support their operations. Students are asked to design and develop a database to allow the airline to track flights, passengers, bookings, and more, based on a set of business rules, default data, and other requirements. The case has been designed for use in a database management course for students having little relational database experience other than the content of the course itself. Teaching notes containing suggestions and a possible solution are provided upon request.