Database Normalisation Questions
The first normal form (1NF) in database normalization is a basic level of normalization that ensures that each column in a table contains only atomic values, meaning that it cannot be further divided into smaller pieces of data. It eliminates repeating groups and ensures that each row in a table is unique. To achieve 1NF, a table must have a primary key that uniquely identifies each row, and each column in the table must contain only single values, avoiding multiple values or repeating groups.