Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
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.
|
Data redundancy
|