THE education site for computer science and ICT
3. Simple Primary Key
There are two types of primary keys:
- Simple
- Compound or composite
Simple primary key
A simple primary key is made up of a single field only.
For example, 'customer ID' in the example below would be classed as a 'simple primary key'
The primary key 'Customer ID' is enough to uniquely identify every record in the table. Simon Jones has the unique value "1" in the primary key field, Emma Price "2", etc.
Challenge: see if you can find out one extra fact on this topic that we haven't already told you
Click on this link: Simple Primary Key