Term
|
Definition
| A database is a collection of data or information which is held together in an organised or logical way. |
|
|
Term
|
Definition
| Databases store data or information in tables. A database can contain many tables. |
|
|
Term
|
Definition
| A record is all of the data or information about one person or one thing. |
|
|
Term
|
Definition
| A 'field' is one piece of data or information about a person or thing. |
|
|
Term
|
Definition
| A database where all of your data is stored in one large table. |
|
|
Term
|
Definition
| A database where different categories of information are kept in different table that are linked through relationships. |
|
|
Term
|
Definition
| A primary key is a field n a table which is unique and enables you to identify every record in that table. |
|
|
Term
|
Definition
| A simple primary key is made up of a single field only. |
|
|
Term
|
Definition
| Combines more than on field to make a unique value. |
|
|
Term
|
Definition
| Made on a fields that you would like to be indexed for faster searches. A table can have more than one secondary key. |
|
|
Term
|
Definition
| A foreign key is used to link tables together and cr4eate a relationship. It is a field in one table that is linked to the primary key in another table. |
|
|
Term
|
Definition
| Referential integrity means that the foreign key in any referencing table must always refer to a valid row in the referenced table. |
|
|
