Database definitions

?
  • Created by: KianDale
  • Created on: 27-11-19 12:40
Database
Database and organised / structured set of data
1 of 10
Flat file Database
One big table
2 of 10
Relational Database
Many tables linked together
3 of 10
Field
An individual item with a record. Each field has a unique name and contains a single data type
4 of 10
Record
A collection of data about a single item, such as a single student or a customer. Each record must be unique
5 of 10
Data Types
A data type is a type of data.
6 of 10
Text
Letters, numbers, punctuation
7 of 10
Number
Letters, numbers, punctuation
8 of 10
Date/Time
Dates or times
9 of 10
AutoNumber
Starts at 1 and counts up automatically for every record
10 of 10

Other cards in this set

Card 2

Front

One big table

Back

Flat file Database

Card 3

Front

Many tables linked together

Back

Preview of the back of card 3

Card 4

Front

An individual item with a record. Each field has a unique name and contains a single data type

Back

Preview of the back of card 4

Card 5

Front

A collection of data about a single item, such as a single student or a customer. Each record must be unique

Back

Preview of the back of card 5
View more cards

Comments

No comments have yet been made

Similar ICT resources:

databases
Teacher recommended
See all ICT resources »See all Data and Information resources »