22-24 Flashcards
(20 cards)
While waiting tables at a local restaurant, your last table ordered steak, lobster, and two soft
drinks. Which elements of the restaurant information system would these items most likely be?
Data
In business, we often use information to reduce ___________.
uncertainty
One study estimated that on average bad information costs businesses up to ______ of their
revenue.
12%
Wikipedia is a collaborative website that defines terms and provides information on many
different subjects. It is not a peer reviewed site. Because of this Wikipedia probably lacks
___________ information quality.
accurate
A ______ or column in a table represents some characteristic of the thing contained within a table.
field
A ______ or row in a table is a set of fields that all pertain to the same thing.
Record
A table in a database contains information about Employees. The EmployeeID uniquely identifies
each entry in the table. What is this known as?
Primary key
A table in a database contains information about Employees. The portion of the table that would
contain the Employee First Name for all Employees would be known as what?
Field
For large and complex amounts of information, storing the information is best achieved by using
what?
A database
In a relational database, a field that references a unique identifier in a related table is known as a:
foreign key
In a relational database, the link between two tables by a primary key and a foreign key is known
as what?
A relationship
What are databases good at, as compared to spreadsheets?
Storing and organizing information
Which of the following is not a disadvantage of using a spreadsheet over a database?
Ease of use
A column in Excel would be know as _____ in a Database.
field
A query in databases is useful for:
building a report of repetitive questions
A row in Excel would be known in a database as:
Record
Which of the following is an example of problems that might occur if you use a spreadsheet for
data storage?
Inconsistent data
Poor data integrity
Difficulty in data retrieval
Unnecessary data duplication
all of the above
Which of the following would be best for the primary key of a student table
Student ID Number
A set of coordinated activities that lead to a specific goal or outcome is known as:
business process
In order to properly register for classes for next semester, the university makes available a
course schedule that is updated in real time. This is most similar to the __________ dimension of
information quality.
timely
