`Location` table

Overview

The Location table will contain information on all the cities that Dairy Air flies to and from.

Fields

Field Name	Key?	Required?	Data Type	Range	Description
Location Number	Yes	Yes	Integer	>= 1	A unique, system-assigned identifier for a given location.
Location Name	No	Yes	String	Alphabetic	The name of the location.
Time Offset	No	Yes	Real	> 0	A number that represents the time difference from Calgary in hours and fractions thereof.

Primary Key

Location Number

Relationships

"Source" Relationships

Every record in the Location database may be linked to at least one record in the Route database. (Every location may be the departure point for many routes)
Every record in the Location database may be linked to at least one record in the Route database. (Every location may be the arrival point for many routes)

"Destination" Relationships

Every record in the Route database will be linked to at least one record in the Location database. (Every route requires a departure point)
Every record in the Route database will be linked to at least one record in the Location database. (Every route requires an arrival point)

Accessor Forms

Form Name	Security Group	Access Rights
Add Route	Flight Schedulers	Read
Delete Route	Flight Schedulers	Read
Add Location	Flight Schedulers	Read/Add
Edit Location	Flight Schedulers	Read/Modify/Delete

Back to index of Changes

Dairy Air comments and questions are in blue emphasis

The links to Add Location and Edit Location are broken. What form is used to access these forms from; the flight information form would be an ideal place to access the Add Location and Edit Locaiton forms.

Security Setting:

Security Group	Admin Access	Read	Add	Modify	Delete
System Admin	X	X	X	X	X
Flight Admin	X	X	X	X	X
Plane Admin
Booking Agents

Location table