Chapter 01 - Database Systems
_____ exists when different versions of the same data appear in different places.
Data inconsistency
Which of the following refers to the situation where different versions of the same data are stored at different places because they weren't updated consistently?
Data redundancy
Data and information are essentially the same thing.
False
Data anomaly is defined as the condition in which all of the data in the database are consistent with the real-world events and conditions.
False
Field refers to a collection of related records.
False
The DBMS reveals much of the database's internal complexity to the application programs and users.
False
_____ is the result of revealing the meaning of raw facts.
Information
Which of the following is true of spreadsheet applications?
They enhance the user's ability to understand the data.
Data constitute the building blocks of information.
True
Metadata describe the data characteristics and the set of relationships that links the data found within the database.
True
One disadvantage of a database system over previous data management approaches is increased costs.
True
The only way to access the data in a database is through the DBMS.
True
A(n) _____ might be written by a programmer or it might be created through a DBMS utility program.
application
The database structure in a DBMS is stored as a _____.
collection of files
A(n) _____ database is used by an organization and supports many users across many departments.
enterprise
A _____ is a character or group of characters that has a specific meaning.
field
A _____ is a collection of related records.
file
End-user data is
raw facts of interest to the end user
Data is said to be verifiable if
the data always yields consistent results.
A(n) _____ database supports a relatively small number of users (usually fewer than 50) or a specific department within an organization.
workgroup