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/13

Click to flip

13 Cards in this Set

  • Front
  • Back

Flat-file Database

May contain a number of single tables with no links between them.

Relational Database

A database which contains anumber of linked tables.

Primary Key

A primary key is a field which uniquely identifies a record in a database.

Foreign Key

A foreign key is a primarykey from one table included in another table to form a link.

Index

Used to improve accesstimes to records.

3rd Normal Form

The data items aredependent on the key, the whole key and nothing but the key.

Data Redundancy

Storing of the same data more than once.

Data Consistency

Due to data being stored only once, all instances of data will be updated if a change is made.

Data Independence

Data in a database should be able to be used on any other database application.

Data Warehousing

Where large quantities of data are collected together from a variety of locations for efficient analysis.

Data Mining

The analysis of large amounts of data (in a data warehouse) to provide new information or find patterns.

Database Administator

The person in a company who is responsible for the structure and management of the database system and the data in it.

Query Language

Used when a user wants to search data in database.