Grand Travel Airlines PILOT FLIGHT PASSENGER RESERVATION AIRPLANE
C

question 44

Essay

Grand Travel Airlines.
a. You have just been named Director of Data Administration of Grand Travel Airlines. Grand Travel Airlines has a centralized, mainframe-based information systems environment at its headquarters with telecommunications links to a server at each airport that it services. Each server, in turn, controls a LAN that includes a microcomputer at each check-in counter and gate. Check-in and other data taken in at the counters and gates is immediately transmitted to the mainframe at headquarters. You have been given the responsibility of creating data administration and database administration departments for Grand Travel Airlines. Design these data administration and database administration departments describing their responsibilities.
b. Create a data dictionary TABLES table and an ATTRIBUTES table and enter data in them for the following Grand Travel Airlines database. Your TABLES table should have Table Name, Table Length, and Disk Number columns. Your ATTRIBUTES tables should have Attribute Name, Attribute Type, and Attribute Length columns. Use your judgement in developing the values for these columns.
$$\begin{array} { | l | l | l | l | } \hline \text { Pilot } & \text { Pilot } & \text { Date of } & \text { Date of }\\\text { Number } & \text { Name } & \text { Birth } & \text { Hire } \\\hline\end{array}$$ PILOT
$$\begin{array} { | l | l | l | l | l | l |} \hline \text { Flight } & & \text { Departure } & \text { Arrival } & \text { Pilot } & \text { Serial } \\\text { Number } & \text { Date } & \text { Time }&\text { Time } &\text { Number }&\text { Number }\\\hline\end{array}$$ FLIGHT
$$\begin{array} { | l | l | l | l | } \hline \text { Passenger } & \text { Passenger } & & \text { Telephone } \\\text { Number } & \text { Name } & \text { Address } & \text { Number } \\\hline\end{array}$$ PASSENGER
$$\begin{array} { | l | l | l | l | l | } \hline \text { Flight }&&\text { Passenger }&&\text { Reservation }\\\text { Number }&\text { Date }&\text { Number }&\text { Fare }&\text { Date }\\\hline\end{array}$$ RESERVATION
$$\begin{array} { | l | l | l | l | l | } \hline \text { serial } & & \text { Passenger } & \text { Year } & \\\text { Number } & \text { Model } & \text { Capacity } & \text { Built } & \text { Manufacturer } \\\hline\end{array}$$ AIRPLANE
c. Create a RELATIONSHIPS table for this tables and attributes data.

---

Definitions:

Prison Rape Elimination Act

A United States federal law aimed at preventing and addressing sexual assault and rape in the prison system.

U.S. Law

The legal framework and body of laws that govern the United States, including the Constitution, statutes, case law, and regulations.

Male Prison Rape

The act of sexual assault among male inmates within correctional facilities, a significant issue affecting the safety and rights of prisoners.

Warning Shots

Discharge of firearms not aimed to hit a target but intended to signal or intimidate opponents or to stop an advance.