DATABASE REVISION
Jordan Curnow

KEYWORDS AND DEFINITIONS

Database

Table

Record

Field

Report

Primary Key

DATA TYPES

Alphanumeric or Text

Currency

Auto Number

Number

Date/ Time

Logical, Boolean, Yes/No

VALIDATION

It is very important to remember that Validation cannot stop the wrong data being entered, you can still enter "Smith" instead of "Smith" or "Brown" instead of "Green" or "78" instead of "87".

PAPER DATABASE EXAMPLES

ELECTRONIC DATABASE EXAMPLES

FLAT FILE DATABASE

RELATIONAL DATABASE

DATA DUPLICATION

DATA REDUNDANCY