Core database concepts

Within this section on the concepts of databases, we will examine:

• data-types of fields

• the hierarchy of fields, attributes, records and tables

• primary and foreign keys

• the links between those keys and

• the data anomalies we hope to avoid with these links.