Flashcards on Database Revision, created by jordanleecurnow on 19/06/2015.
|
Created by jordanleecurnow
about 9 years ago
|
|
Close
|
|
Created by jordanleecurnow
about 9 years ago
|
|
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
