Databases Flashcards
(20 cards)
This checks that data has been entered
Presence check
Allow user to choose from drop down list
Restricted choice
Specific number or characters a field can hold
Length check
Range of numbers data must lie within when entered
Range check
Data that appears more than once
Data duplication
Linked tables to reduce data duplication
Relational database
Data has been entered twice but is different in each case
Data anomalies
A key that uniquely identifies a record
Primary key
A primary key in a other people table and used to link two tables
Foreign key
Stores true or false value
Boolean
A - Z or 0 - 9
Ascending order
Z - A or 9 - 0
Descending order
A row in a table
Record
One item of information in the record
Field
The whole database
File
Sort on one field
Simple sort
Sort on 2 or more fields
Complex sort
Search on one field
Simple search
Search on 2 or more fields
Complex search
A single table not linked to any other tables
Flat file
