That's all good (well, modulo a minor normalization quibble), except the full text search:

select ... from ... where BodyPart like '%foo%' ...
[download]

On a small dataset this will be OK, but it won't scale, as it requires a table scan (or at the very least a full index scan if BodyPart is indexed) for databases that use B-Tree (and derived) indexes due to the leading wild-card (%).

Michael