medium
1 min read
1NF
1NF (First Normal Form) A relation in 1NF is a relation in which each attribute represents a single atomic fact. An atomic fact is a piece of information th...
Quick Actions
Insights
Difficultymedium
Reading Time1 min
1NF (First Normal Form) A relation in 1NF is a relation in which each attribute represents a single atomic fact. An atomic fact is a piece of information th...
1NF (First Normal Form)
A relation in 1NF is a relation in which each attribute represents a single atomic fact. An atomic fact is a piece of information that can be identified with a single value, such as the name of a student, a student's address, or a student's course.
For example, the relation Students(name, address, course) would be in 1NF, as each attribute represents a single atomic fact.
Here are some examples of relations in 1NF:
Students(name, address, course)
Orders(customer_name, order_date, total_price)
Professors(name, specialty)
Benefits of being in 1NF:
1NF is easier to process and query than relations in higher normal forms.
1NF is more robust to data errors, as changes to one attribute will only affect a single row in the relation.
1NF is the minimum level of normalization, meaning that any relation that is not in 1NF can be transformed into a relation in 1NF