Grand Travel Airlines PILOT FLIGHT PASSENGER RESERVATION AIRPLANE
C

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.