Databases

HideShow resource information
Databases
A collection of data or information stored electronicallu in an organsied/ logical way.
1 of 11
Records
All of the data or information about 1 person or thing
2 of 11
Fields
One piece of data it information about a person or thing
3 of 11
Data type- Text
This is for data saved in alphabetical order or a mixture of letters and numbers
4 of 11
Data Type- Number
This is for data saved in numeric format
5 of 11
Data Type- Currency
this is for data saved in monetary values
6 of 11
Data type- Date and Time
this is saved in date format
7 of 11
Data Type- yes/no
can be one of two answers
8 of 11
Data type- Auto number
this is for data that would have a unique number
9 of 11
Primary Key
field in a table which is unique and enables you to identify every record in that table.
10 of 11
Composite Key
a combination of two or more columns in a table
11 of 11

Other cards in this set

Card 2

Front

All of the data or information about 1 person or thing

Back

Records

Card 3

Front

One piece of data it information about a person or thing

Back

Preview of the back of card 3

Card 4

Front

This is for data saved in alphabetical order or a mixture of letters and numbers

Back

Preview of the back of card 4

Card 5

Front

This is for data saved in numeric format

Back

Preview of the back of card 5
View more cards

Comments

No comments have yet been made

Similar ICT resources:

See all ICT resources »See all Databases resources »