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

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


Play button


Play button




Click to flip

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.
A single characteristic or attribute of a person, place object, event, or idea.
A complete set of field values for a specific person, place, object, event, or idea
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