`Plane` table

Overview

The Plane table will contain one record for every plane utilized by Dairy Air.

Field Name	Key?	Required?	Data Type	Range	Description
Plane Number	Yes	Yes	Integer	>= 1	A unique system-assigned number for the plane.
Plane Type	No	Yes	String	Alphabetic	A description of the plane.
Plane Capacity	No	Yes	Integer	>= 1	The total passenger capacity of the plane.
Location	No	Yes	Integer	>= 1	A number representing the location of the plane.

Dairy Air comments and questions are in blue emphasis

If location is stored as an integer, it must be displayed to the end user as the city name, not an arbitrarily assigned number.

Every record in the Plane table will be linked to many records in the Seat table. (Every plane has at least one seat)
Every record in the Plane table will be linked to many records in the Flight table. (One plane can fly many flights, although not simultaneously!)
Every record in the Plane table will be linked to one record in the Location table. (One plane can be in one location at once)

One record in the Location table may be linked to many records in the Plane table. (One location may have many planes)
One record in the Seat table will be linked to one record in the Plane table. (One seat is on a specific plane)
One record in the Flight table will be linked to one record in the Plane table. (Every flight must be flown by a specific plane)

The table below shows the forms that will access the Plane database, the authorized users of those forms, and the table access level.