When is a table in 1NF?
2 years ago
Database Management System
A table is in 1NF when all the key attributes are defined (no repeating groups in the table) and when all remaining attributes are dependent on the primary key. However, a table in 1NF still may contain partial dependencies, i.e., dependencies based on only part of the primary key and/or transitive dependencies that are based on a non-key attribute.
A table is in 1st Normal Form (1NF) when it meets the following criteria:
- Each row of the table represents a single, unique entity (i.e. there are no repeating groups of data in a single row)
- Each column of the table has a single, atomic (indivisible) value (i.e. no cells contain multiple values)
- The table has a primary key, which uniquely identifies each row in the table.
Bijay Satyal
Oct 23, 2021