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