`Seat` table

Overview

The Seat table will contain many records for each plane in Dairy Air's fleet. Each record will contain, at the very least, the seat number and seat type.

Fields

Field Name	Key?	Required?	Data Type	Range	Description
Plane Number	Yes	Yes	Integer	>=1	The plane that this particular seat is on.
Seat Number	Yes	Yes	Integer	>=1	A unique number assigned to each seat on a plane.
Seat Type	No	Yes	Enumerated	{WINDOW, CENTER, AISLE}	The seat's type.
Ticket Number	No	No	Integer	>=1	The ticket that has "bought" that seat.

Back to index of Changes

Dairy Air comments and questions are in blue emphasis

Please expand on the reasoning behind the entry "Ticket Number". What is its purpose? Many people may buy tickets on a flight yet not all can have a seat (15% overbooking policy). Seats are not assigned when tickets are purchased, thus this field may be empty for most of the time a flight is in the system.

Primary Key

Plane Number
Seat Number

Relationships

"Source" Relationships

Each record in the Seat database may be linked to one record in the Ticket database. (Each seat may be filled by one ticket)
Each record in the Seat database will be linked to one record in the Plane database. (Each seat is on board some plane)

"Destination" Relationships

Each record in the Plane database will be linked to at least one record in the Seat database. (Each plane has at least one seat)
Each record in the Ticket database may be linked to one record in the Seat database. (Each ticket may occupy some seat)

Accessor Forms

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

Form Name	Security Group	Access Rights
Plane Information	Plane Administration	Read/Add/Modify/Delete
Boarding	Booking Agent	Read//Modify

Security Setting:

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

Seat table