Airline Reservations (Booking) System

Following is the data model of Airline Reservations (Booking) System.

Requirements
Aeroplane
Aeroplane Types
Destination
Starting from
Flights
Passengers
Reservations
Seats
Tickets
Ticket Types
Travel Class

Relationships
A passenger can have zero or many Reservation.
A Reservation can be for one and only one passenger.
A group booking can be for one or many passengers.