Part 1: Draw data models for the following entities. In each case, make certain that you show the attributes and identifiers. Also, create a relational database and insert three rows for each of the tables that you create. The data can be anything you create that fits within any constraints specified in the problem.

1. An aircraft can take many flights, but each flight is on only one aircraft. A flight can have many passengers, but a passenger can be on only one flight at a time. For each aircraft we want to track the make, model, and year manufactured. For each flight we want to track the origin, destination, date, departure time, and arrival time. For each passenger we want to track the passengers last name, first name, street address, city, state, zip code, seat number, and class (e.g. first, business, or coach).