Use the following images to answer the multiple choice questions below. Right cl
ID: 3566345 • Letter: U
Question
Use the following images to answer the multiple choice questions below.
Right click on image to view it and adjust its size to your preferences.
Which of the following illustrates redundant (i.e., unnecessarily repeated) information in the Reservations spreadsheet?
Income repeats for each trip planned by a given tourist.
tID repeats for each trip planned by a given tourist.
C.) There is no redundant information in the spreadsheet.
D.) dCountry repeats for each tourist planning a visit there.
Question 2
change to the Reservations spreadsheet, assuming that a row cannot have any empty cells?
This change results in a loss of information.
This change cannot be represented.
This change requires updating only one existing row in the spreadsheet.
This change requires updating multiple existing rows in the spreadsheet.
Question 3
Suppose we learn of tourist t5, named Nash, whose income is 35000. Which choice best describes the change to the Reservations spreadsheet, assuming that a row cannot have any empty cells?
This change requires updating multiple existing rows in the spreadsheet.
This change results in a loss of information.
This change cannot be represented.
This change requires updating only one existing row in the spreadsheet.
Question 4
Suppose Brittany
A.)Income repeats for each trip planned by a given tourist.
B.)tID repeats for each trip planned by a given tourist.
C.) There is no redundant information in the spreadsheet.
D.) dCountry repeats for each tourist planning a visit there.
Here's a list of data for a travel agency that's keeping track of which tourists have reservations for visiting which countries. For example, the tourist with ID t1, whose name is Shanika and whose income is 80000, has a reservation for a trip to Armenia, whose population in thousands is 3083, next to be visited in 2012. Next, consider breaking down the Reservations spreadsheet, as follows, into three spreadsheets without the unnecessary redundant information: Consider the following when answering questions 10-12: A primary key is a column (or combination of columns) that will always identify exactly one row in a spreadsheet even if the data in the spreadsheet change. Since the purpose of a primary key is to identify uniquely a row in the spreadsheet, the value for the primary key typically does not change over time. A spreadsheet has only one primary key. Consider the following when answering questions 13-15: A foreign key is a column (or combination of columns) in a spreadsheet that refers to the values of a primary key in some spreadsheet. A spreadsheet does not have to contain a foreign key, and it may contain more than one foreign key.Explanation / Answer
1.d
2b
3.b
4.c
5.d
6.a
7.a
8.a
9.b
10.c
11.d
12.b
13.c
14.b
15.a
16.b
17.c
18.a
19.b
20.c