Reading...
Play button
Play button
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;
7 Cards in this Set
- Front
- Back
|
What is a field?
|
Single characteristic or attribute ofa person, place, object, event, or idea. Smallest piece of information in a database.
|
|
|
What is a field value?
|
The specific value, or content, of a field.
|
|
|
What is a record?
|
A set of field values. All the pieces of information about a particular person, place, object, event, or idea.
|
|
|
What is a table?
|
A collection of records that describe a person, place, object, event or idea. Also, 2-D structure made up of rows and columns of data in a relational database in which each row is unique, row order is unimportant, each column has a unique field name, column entries are from the same domain, and each row describes a single entity.
|
|
|
What is a relational database?
|
A collection of related tables, usually linked by common fields.
|
|
|
What is a primary key?
|
A field whose values uniquely identify each record in a table. E.g., SS# for student records, or VIN for automobiles registration records.
|
|
|
What is a foreign key?
|
A primary key field from one table that you include as a field in a second table to form 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 or some table or must be null.
|
