1. Create an ERD for the reservations system.
2. Create 3NF table designs for the system.
3. Use sample data to populate the fields for three records.

FastFlight Airlines is a small air carrier operating in three northeastern states. FastFlight is computerizing its passenger reservation system. The data items must include reservation number, flight number, flight date, origin, destination, departure time, arrival time, passenger name, and seat number. For example, flight number 303 leaves Augusta, Maine, daily at 9:23 a.m. and arrives in Nashua, New Hampshire, at 10:17 a.m. A typical reservation code might be AXQTBC, for passenger Lisa Lane, in seat 4A, on flight 303 on 11/12/2011.