Data modelling - Concept
Record
One complete item in a set of data, usually shown as a row containing several pieces of information
What's it for?
Keeps all the information about one item together so it can be found, changed and reported on.
For example…
Updating a customer record with a new billing address stops invoices going to the old office.
One row containing CustomerID 123, name, email and account status is a single customer record
Think of it like…
One filled-in form in a stack of forms