Flyme Corporation is an airline and needs a database that can store the flights for their company, the passengers on each flight, the pilots on each flight, and the flight attendants for each voyage. Once complete the goal will be the customer can reserve a spot on a particular trip and also see their travel history and miles flown. The employees on the flight will also be able to check their upcoming weekly schedules and also see their history and hours in the air. In addition, every plane would need to be monitored for hours in use.
Pilots for Flyme have a distinct role. They can be the captain, co-pilot or Flight Engineer
Finally, Flyme would like to know the actual maintenance done on each plane. In other words, the date of the work, the work completed, by whom, and how many hours would be on the plane when maintained. The work on each plane will be completed by Flyme’s own maintenance workers.