-remove repeating attributes and create a new entity containing them
-new entity must contain a composite key
1 of 3
2nd Normal Form
-focus only on your new repeating entity and look for a dependency between the non-key attributes and the 2nd part of the composite key
-if there is a dependency remove it into a new entity
2 of 3
3rd Normal From
-focus on every entity but only on the non-key fields, look for a dependency between non-key fields in each entity
-if there is a dependency move them into a new entity
Comments
No comments have yet been made