Ian has attended:
Access Intermediate course
Access Advanced course
Normalisation
What is first normal form?
RE: Normalisation
The definition for first normal form (1NF) is:
Each column must contain only a single value and each row must contain the same columns.
In 1NF a table must be guaranteed not to have any duplicate records; therefore it must have at least one Primary key.
There must be no repeating groups. For example, suppose that an employee can have multiple skills: a possible representation of employees' skills is {Employee ID, Skill1, Skill2, Skill3 ...}, where {Employee ID} is the unique identifier for a record. This representation would not be in 1NF.