Normalizing the Database (Part 2 of 5), First Normal Form
To have a table in first normal form (1NF):
> The table must be two-dimensional with rows and columns describing a table object.
> Each row must have data that relates to the table object and no two rows can be identical.
Each table must have a primary key that uniquely identifies every row.
The primary key can consist of one column (simple key) or multiple columns (composite key).
> Each column must have a unique column name and contain data that describes an attribute of the table object and all of the column values must describe only that single attribute.
Each column must be consistent with a single data type. If this column is for a numeric phone number, then all entries in this column can only be numeric phone numbers.
> Each row and column value must be only a single value.
