Databases Flashcards
1
Q
This checks that data has been entered
A
Presence check
2
Q
Allow user to choose from drop down list
A
Restricted choice
3
Q
Specific number or characters a field can hold
A
Length check
4
Q
Range of numbers data must lie within when entered
A
Range check
5
Q
Data that appears more than once
A
Data duplication
6
Q
Linked tables to reduce data duplication
A
Relational database
7
Q
Data has been entered twice but is different in each case
A
Data anomalies
8
Q
A key that uniquely identifies a record
A
Primary key
9
Q
A primary key in a other people table and used to link two tables
A
Foreign key
10
Q
Stores true or false value
A
Boolean
11
Q
A - Z or 0 - 9
A
Ascending order
12
Q
Z - A or 9 - 0
A
Descending order
13
Q
A row in a table
A
Record
14
Q
One item of information in the record
A
Field
15
Q
The whole database
A
File
