First normal form (1NF)

To conform to the first normal form, a table must have:

• No attribute (cell) with multiple values
• A primary key defined as a single column or a set of columns (composite key)

Let's try to convert our spreadsheet into a database table. Evidently, our Power column breaks the first rule.

The updated table here satisfies the first normal form. The primary key (marked with a *) is a combination of Name and Power, which should be unique for each row: