Normalizing the Data › How To Normalize Data › Listing Data in Second Normal Form

Listing Data in Second Normal Form

To verify that all entities are in second normal form, perform the following steps:

1. Identify entities with compound keys. Entities with compound keys are sometimes in first normal form but not in second normal form. Therefore, you need to carefully examine each entity that has more than one attribute in its primary key. By definition, entities with atomic keys are in second normal form (that is, if the entity contains no repeating groups and you selected an appropriate attribute as the primary key).
2. Remove partially dependent attributes:
   1. Locate any attributes that are dependent on only part of a compound key.
   2. Remove these attributes and create a new entity. Create a new relationship to relate the new entity to the entity from which it was removed.
3. Update the E-R diagram to reflect these changes.

Dental claim information in second normal form

The entities and relationships that describe dental claim information are listed in second normal form in the following table. No changes were made to organize the information in second normal form.