Term
|
Definition
| A collection of related structured data. |
|
|
Term
|
Definition
| All the data is concerned/has the same purpose or theme.I.e. music students or cars. |
|
|
Term
|
Definition
| All the information stored has the same variety of detail for each item (student)in the file. |
|
|
Term
|
Definition
| Something like a questionnaire (the details from a single person) would be a record. |
|
|
Term
|
Definition
| Each separate detail e.g. students name on a questionnaire would be a field. |
|
|
Term
|
Definition
| Each record has the same set of fields. |
|
|
Term
|
Definition
| A field that includes data like the registration number plate of a car or a student identification number. |
|
|
Term
|
Definition
| A collection of data held in a single table.Meaning data can only be viewed in a limited way. |
|
|
Term
|
Definition
| Data that can be held in a number of tables where links (or relationships) are created to connect the data in different tables to each other. |
|
|
Term
|
Definition
| The key field such as 'Registration'. |
|
|
Term
|
Definition
| A field that links two files and creates a relationship between them, like 'customer id'. |
|
|
