– Any nonkey attributes dependent on only part of the primary key should be moved to entity where that partial key is the full key. May require creating a new entity
and relationship on the model.
Third normal form (3NF) – entity whose nonprimary-key attributes are not dependent on any[r]