Search⌘ K
Home
Courses
Database Design Fundamentals for Software Engineers

First Normal Form

Explore how to apply First Normal Form (1NF) to database tables by ensuring that all attribute values are atomic and indivisible. Understand how this step eliminates multi-valued attributes and prepares you for further normalization processes to improve database efficiency and structure.

We'll cover the following...

First normal form (1NF)

First normal form (1NF) states that the domain of an attribute must include only atomic (simple, indivisible) values and that the value of any attribute in a tuple must be a single value from the domain of that attribute. Hence, 1NF disallows having a set of values, a tuple of values, or a combination of both as an attribute value for a single tuple. The only attribute values permitted by 1NF are single atomic (or indivisible) values. In other ...