Data modelling - Concept
Field
One named piece of information held for each record, usually shown as a column
What's it for?
Stores one specific piece of information about a record in a consistent place.
For example…
The “leave balance” field on a staff record shows how many holiday days remain.
On a customer record, First name, Email address and Account status are separate fields, each holding one specific value
Think of it like…
One labelled box on a form you fill in