Django Design Patterns and Best Practices - Second Edition

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:

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 ...