WorksheetsDatabase
Total questions: 23
Worksheet time: 16mins
A ________ is a collection of related data that can be stored, sorted, organized, and queried.
database
spreadsheet
memo
macro
If a school keeps two lists, one for student registration and one for student financial information, both containing name and address information, this is an example of data ________.
integrity
redundancy
completeness
normalization
Match each of the following terms to its definition:
I. field
II. database
III. record
IV. table
V. primary key
A. a group of related fields
B. a category of information in a database
C. a collection of related data that can be stored, sorted, organized, and queried
D. a field that has a value unique to each record
E. a group of related records
(a)
Data ________ means that the data contained in a database is accurate and reliable.
efficiency
integrity
redundancy
consistency
In a database, the term ________ is synonymous with a category of information.
field
record
row
table
In a database, a group of related records is referred to as a(n) ________.
memo
field
object
table
A database that allows data to be maintained in a single location provides data
(a) .
In an employee database, an employee's ID number, last name, first name, company position, address, city, state, and Zip Code make up a record.
True
False
You can set a ________, which is automatically displayed in a field unless the user enters something different.
default value
relation
field type
numeric check
Data that describes other data is called (a) .
When working with a relational database, each record must have a(n) (a) key field, which has a value unique to that record.
Small slices of a data mart are called data warehouses.
True
False
In a relational database, when two tables have a common field, the link between the tables is known as a hyperlink.
True
False
Match each of the following terms to its definition:
I. data mining
II. expert system
III. data mart
IV. artificial intelligence
V. data staging
A. small slice of a data warehouse
B. includes transforming data to fit into a data warehouse
C. process by which great amounts of data are analyzed and investigated
D. software that tries to replicate the decision making of human specialists
E. attempts to create computers that think like humans
(a)
Which of the following is a likely primary key in a student information record?
Last name
Date of birth
Student ID number
First name
________ is used to ensure that data is organized most efficiently in a database.
Consistency checking
Validation
Normalization
Range checking
A data ________ is a large-scale collection of data that contains and organizes all of an organization's data in one place.
mart
chain
warehouse
storehouse
________ is the branch of computer science that attempts to create computers that think like humans.
Natural language processing
Expert systems
Artificial intelligence
Enterprise resource planning
In a Microsoft Access database, an active web page, e-mail address, or existing file is stored as a(n) (a) field.
A(n) (a) report provides a consolidated picture of detailed data and usually includes some calculation or visual displays of information and is generated by a MIS.
(a) is used to analyze large amounts of data and identify unseen patterns or trends.
Employees' last names would usually make an appropriate primary key field.
True
False
Most databases can import electronic data from other software applications.
True
False
