Second Normal Form

The result of normalizing to ensure that a data model contains no partial key dependencies. In practice, when entities have compound keys, seek out any attribute that is dependent upon only part of the key. Whatever business thing is identifiable by that part of the key is an entity, and the 2NF violation is an attribute of that entity.

Get your copy of Information Governance World!

WordPress Image Lightbox
Scroll to Top