What is a database
A database is an organised, permanent, store of data. Databases contain one or more tables (Shown by the blue box below). Columns in the table are fields (Shown in red below) about which data is held. Each row in a table is
a record (Shown by the red box below).
Each table will have a primary key field (Shown shaded blue below). This is a field that will be unique in every record. If such a field does not exist in a table already an ID field may be created.