 |
 |
 |
|
 |
|
 |
|
|
 |
 |
 |
First normal form (1NF)
- First normal form:
- A relation is in first normal form if every attribute in every row can contain only one single (atomic) value.
A university uses the following relation:
Student(Surname, Name, Skills)
The
attribute Skills can contain multiple values and therefore the relation is not
in the first normal form.
But the attributes
Name and Surname are atomic attributes that can contain only one value.
Example First normal formTo get to the first normal form (1NF) we must create a separate tuple for each value of the multivalued attribute
 |
|
|
|
|
|
|
|
