`Route` table

Overview

The Route table will contain information about routes flown by Dairy Air.

Field Name	Key?	Required?	Data Type	Range	Description
Route Number	Yes	Yes	Integer	>= 1	A system-assigned, unique value for each route.
Departure Location	No	Yes	Integer	>= 1	The departure location's number.
Arrival Location	No	Yes	Integer	>= 1	The arrival location's number.
Departure Time	No	Yes	Time	24-hour clock	The time the flight departs.

Every record in the Route database will be linked to one record in the Location database. (Every route must depart from a location)
Every record in the Route database will be linked to one record in the Location database. (Every route must arrive at a location)
Every record in the Route database may be linked to at least one record in the Flight database. (A route may be serviced by at least one flight)

Every record in the Flight database may be linked to a record in the Route database. (A flight must run over a specified route)
Every record in the Location database will be linked to at least one record in the Route database. (A location may be the departure point for many routes)
Every record in the Location database will be linked to at least one record in the Route database. (A location may be the arrival point for many routes)

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

Dairy Air comments and questions are in blue emphasis

The links to Add Location and Edit locaiton are broken.