To convert data in first normal form to second normal form,
concentrate on those records with concatenated keys, check
each nonkey attribute to see if it depends on the entire key, and
move any data element that depends on only part of the key to a
new entity new entity