1.1 Summary: 1NF
- A relation is in 1NF if it contains no repeating groups.
- To convert an unnormalised relation to 1NF either:
- Flatten the table and change the primary key, or
- Decompose the relation into smaller relations, one for the
repeating groups and one for the non-repeating groups.
- Remember to put the primary key from the original relation into both new relations.