ICT data types

?
File
A full set of data.
1 of 26
Record
A file split into sets of data (the rows)
2 of 26
Item
A single piece of data in a record.
3 of 26
Field
Where items are stored in different categories (the columns)
4 of 26
Key field
A field where each item in a record is unique.
5 of 26
Sequential file
Records in a file that are in some sort of order.
6 of 26
Serial file
If the records in a file are in no order, even if the files are in order of input.
7 of 26
Index
Tells you where to find a record, and it is in order.
8 of 26
Direct access file
A serial file with an index.
9 of 26
Data types
Certain boundaries within a field, that the items must be within.
10 of 26
Numeric data types (list)
Integers, real numbers.
11 of 26
Alphanumeric data types
Text.
12 of 26
Logical/ Boolean data types
Can only be one of two characters, e.g. Y or N
13 of 26
Currency
A real number, but can only have two digits.
14 of 26
Validation
Rules about the format, range, or length of the data in a field.
15 of 26
Validation check
Testing whether the data follows the rules: length check, character check, format check, presence check.
16 of 26
Data verification
Compares the output to the original to make sure they match, or they input the data twice.
17 of 26
Flat file
All the data is stored in one file.
18 of 26
Secondary key
An additional key to the primary key.
19 of 26
Table
Another name for a file.
20 of 26
Relation tables
Files that are related to each other.
21 of 26
Foreign key
A field in one file, that is also the key field in another file.
22 of 26
Analogue data
Data that can have any value within a defined range.
23 of 26
Digital data
Data in the form of unique patterns of 0s and 1s (bits, bytes)
24 of 26
Analogue-to-digital converter
A devise that converts analogue data to digital.
25 of 26
Digital-to-analogue converter
A devise that converts digital data to analogue data.
26 of 26

Other cards in this set

Card 2

Front

Record

Back

A file split into sets of data (the rows)

Card 3

Front

Item

Back

Preview of the front of card 3

Card 4

Front

Field

Back

Preview of the front of card 4

Card 5

Front

Key field

Back

Preview of the front of card 5
View more cards

Comments

No comments have yet been made

Similar Computing resources:

See all Computing resources »See all Data types resources »