Untitled

Page 1

Databases

Data:

Raw facts and figures with no meaning

Information:

data that has been given meaning by a structure or context.

Knowledge:

Information that has been processed to find things out.

Database:

Structured store of data, often held on a computer.

Made up of tables.

Table:

The structure used to store data.

Made up of fields and records.

Also known as an entity.

Record

A row in a table which relates to a specific object or person.

Field:

a column in a table which contains the data relating to the scene characteristic for all of the records.

Also known as an attribute.

Data Type:

The sort of data contained in one field for all records.

Text, Number, Data/Time, Boolean (Yes/No), Currency

New Page