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:
Name* |
Origin |
Power* |
Latitude |
Longitude |
Country |
Time |
Blitz |
Alien |
Freeze |
+40.75170 |
-73.99420 |
USA |
2014/07/03 23:12 |
Blitz |
Alien |
Flight |
+40.75170 |
-73.99420 |
USA |
2013/03/12 11:30 |
Hexa |
Scientist |
Telekinesis |
+35.68330 |
+139.73330 ... |