Normalisation

?

1st Normal Form

-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

3 of 3

Comments

No comments have yet been made

Similar ICT resources:

See all ICT resources »See all Databases resources »