Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/7

Click to flip

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.