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.

All of the Following Are Characteristics of Relational DBMS Catalogs

Multiple Choice

Correct Answer:VerifiedUnlock this answer nowGet Access to more Verified Answers free of chargeAccess For Free

Correct Answer:
Verified
Unlock this answer now
Get Access to more Verified Answers free of charge