| Terms |
|
Definitions |
| Field | |
Data that has been suitably
formatted. |
| Table | |
Stores data about a particular entity or
object and is the chief structure in any database |
| Information | |
The data or group of fields about an entity
e.g. a completed form |
| Primary Key | |
A field that provides a link to a Primary
Key in a related table |
| Foreign Key | |
A fact about an Entity. It represents an
attribute of an entity and is used to store data in the database e.g. each
item on form |
| Record | |
A field that uniquely identifies each
record. |