Exam (elaborations) CHP 14 - DATABASES AND DATABASE MANAGEMENT SYSTEMS

CHP 14 - DATABASES AND DATABASE
MANAGEMENT SYSTEMS REVIEW TEST
Database - CORRECT ANSWER-A collection of related data that is stored in a manner
enabling information to be retrieved as needed; in a relational database, a collection of
related tables.

Database management system (DBMS) - CORRECT ANSWER-A type of software
program used to create, maintain, and access databases.

Table - CORRECT ANSWER-In a relational database, a collection of related records or
rows.

Field - CORRECT ANSWER-A single category of data to be stored in a database, such
as customer names or employee telephone numbers. Also called a column.

Column - CORRECT ANSWER-A field in a database.

Record - CORRECT ANSWER-A collection of related fields in a database. Also called a
row.

Row - CORRECT ANSWER-A collection of related fields located in a single table in a
database.

Primary key - CORRECT ANSWER-A specific field in a database table that uniquely
identifies the records in that table.

Entity - CORRECT ANSWER-Something (such as a person, object, or event) that is
important to a business or organization; typically becomes a database table in a
database system for that business or organization.

Attribute - CORRECT ANSWER-A characteristic of an entity.

Data definition - CORRECT ANSWER-The process of describing the properties of data
that is to be included in a database table.

Data dictionary - CORRECT ANSWER-The repository of all data definitions in a
database.

Metadata - CORRECT ANSWER-Data about data, such as the data contained in a data
dictionary.

Data integrity - CORRECT ANSWER-The accuracy of data.