Step $1\mathrm{.}1-$ Create the AIRPLANE Table

Create a new table using the Design View $($Create $=>$ Table Design$)$ command.

In the Field Name column, enter all the attributes as shown in the AIRPLANE table definition. Make sure the Data Type pertaining to each field is of the correct type.

Use the "Description $($Optional$)"$ column in the Design View to describe the type of information that goes in each of those fields $($e$.$g$.$ for the plane$\_$Model field, state that the field captures the plane's manufacturer's model number$)$

Make sure that the plane$\_$Tail field is designated as the primary key for this table. To set a field as your primary key, you can right click the field name and select Primary Key. Indicate this is the primary key field in the field description.

Save this table by clicking on the save icon on the top$-$left corner. You will be prompted for a name. Name the table "AIRPLANE".

Now that you have at least one database object created, you save your database file using the notation specified under SUBMISSION INSTRUCTIONS. Make sure to save your database file regularly so that you do not lose any work. Whenever you are finished working on your file, make sure that it has been saved and stored somewhere that you can open or download from at a later time.

Step $1\mathrm{.}2-$ Create the SEAT, PASSENGER, and FLIGHT Tables

For the SEAT, PASSENGER, and FLIGHT tables, repeat the steps from Step $1\mathrm{.}1,$ referring to the appropriate table definitions and assigning the correct primary keys.

Step $1\mathrm{.}3-$ Populate AIRPLANE, SEAT, PASSENGER, and FLIGHT Tables

Populate the AIRPLANE, SEAT, PASSENGER, and FLIGHT tables before proceeding to the next step. Sample data has been provided in a separate spreadsheet published on Brightspace for the AIRPLANE, SEAT, and FLIGHT tables. For the PASSENGER table, create $10$ passenger records with made$-$up information for testing, with one of them having your name and university emall. Note that you will need to populate airplanes before you can populate seats.