Consider the Following Airplane and Flight Files from Grand Travel

question 75

Essay

Consider the following Airplane and Flight files from Grand Travel Airlines. The unique identifier for flights is the combination of flight number and date. Arrival and departure times are actual, not scheduled, times. The left-hand column of relative record numbers is there to facilitate answering some of the questions.
$\begin{array}{lr}&\text { Airplane } \quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad \text { Passenger \quad Year }\\&\text { Number \quad Manufacturer \quad Model\quad Capacity \quad Built }\\\begin{array}{lr}1\\2\\3\\4\\5\\\end{array}&\begin{array}{|l|l|l|r|r|}\hline 04653 \quad & \text { Boeing }\quad \quad & 767\quad & 280\quad & 1988\quad \\\hline 10582 & \text { Airbus } & \text { A320 } & 256 & 1997 \\\hline 16420 & \text { Canadair } & \text { CRT } & 54 & 2001 \\\hline 22663 & \text { Boeing } & 767 & 265 & 1999 \\\hline 28352 & \text { Boeing } & 767 & 280 & 1989 \\\hline\end{array}\\\end{array}$ Airplane file
$\begin{array}{ll}&\text { Flight } \quad\quad\quad\quad\quad\quad \text { Departure\quad Arrival\quad\quad\quad Airplane }\\&\text { Number } \quad \text { Date } \quad\quad \text { Time } \quad\quad\quad \text { Time\quad\quad\quad Number }\\\begin{array}{ll}1\\2\\3\\4\\5\\6\\7\\8\\9\\10\\11\\12\end{array}&\begin{array}{|r|r|r|r|r|}\hline 005 & 11 / 15 / 2003 & 2: 14 \mathrm{PM} & 4: 20 \mathrm{PM} & 22663 \\\hline 018 & 01 / 24 / 2004 & 11: 00 \mathrm{AM} & 1: 32 \mathrm{PM} & 10582 \\\hline 032 & 11 / 15 / 2003 & 9: 03 \mathrm{AM} & 10: 30 \mathrm{AM} & 16420 \\\hline 032 & 11 / 16 / 2003 & 8: 57: \mathrm{AM} & 10: 23 \mathrm{AM} & 16420 \\\hline 032 & 11 / 17 / 2003 & 9: 00 \mathrm{AM} & 10: 33 \mathrm{AM} & 16420 \\\hline 120 & 01 / 24 / 2004 & 7: 52 \mathrm{PM} & 9: 34 \mathrm{PM} & 16420 \\\hline 120 & 01 / 28 / 2004 & 7: 51 \mathrm{PM} & 9: 57 \mathrm{PM} & 16420 \\\hline 154 & 11 / 15 / 2003 & 12: 58 \mathrm{PM} & 3: 30 \mathrm{PM} & 10582 \\\hline 197 & 02 / / 12 / 2004 & 5: 03 \mathrm{PM} & 7: 22 \mathrm{PM} & 22663 \\\hline 197 & 02 / / 13 / 2004 & 5: 00 \mathrm{PM} & 7: 31 \mathrm{PM} & 28352 \\\hline 197 & 02 / / 14 / 2004 & 5: 03 \mathrm{PM} & 8: 45 \mathrm{PM} & 04653 \\\hline 197 & 02 / / 15 / 2004 & 5: 00 \mathrm{PM} & 7: 28 \mathrm{PM} & 22663 \\\hline\end{array}\end{array}$
Flight file
a. 16420 appears as an airplane number in record 3 of the Airplane file and in records 3, 4, 5, 6, and 7 of the Flight file. Does this constitute redundant data? Explain.
b. Why does the Airplane Number field appear in both files?
c. What would you have to do to find the name of the manufacturer of the airplane used for flight 197 on 02/13/2004?
d. Merge the two files into one based on which records of one file are related to which records of the other file.
e. How does merging the two files into one affect data integration?
f. How does merging the two files into one affect data redundancy?

---

Definitions:

Source of E-Evidence

Origin or provider of digital data or electronic records that can be used as evidence in legal proceedings or investigations.

Metadata

Embedded electronic data recorded by a computer in association with a particular file, including location path, creator, date created, date last accessed, hidden notes, earlier versions, passwords, and formatting. Metadata reveals information about how, when, and by whom a document was created, accessed, modified, and transmitted.

Electronic Data

Information that is stored in a digital format and can be retrieved via electronic devices.

Chain of Custody

The chronological documentation or paper trail that records the sequence of custody, control, transfer, analysis, and disposition of physical or electronic evidence.