Card Range To Study

11 Cards in this Set

Front

Back

A collection of related tables

Relational database

A collection of fields that describe a person, place, object, event, or idea. Also, a two-dimensional structure made up of two rows and columns of data in a relational database in which each row is unique, row order is unimportant, all entries are single-valued, column order is unimportant, each column has a unique field name, column entries are from the same domain, and each row describes a single entity.

Table

A single characteristic or attribute of a person, place object, event, or idea.

Field

A complete set of field values for a specific person, place, object, event, or idea

Record

The specific value, or content, of a field in a record

Field value

A field that appears in more than one table, allowing you to connect the records in a separate table.

Common field

A field, or collection of fields, whose values uniquely identify each record in a table.

Primary key

A primary key field from one table that you include as a field in a second table forms a relationship between the two tables. Also, a field or a collection of fields in one table whose values must match the values of the primary key of some table or must be null.

Foreign key

A software program that lets you create databases and then manipulate data in them.

Database Management System

A primary key that consists of two or more fields

Composite key

A condition that occurs when you store the same data in more than one place; it wastes stored space and can cause inconsistencies.