19 Jul
2007
19 Jul
'07
00:52
Hallo Neil,
The xxxStrength properties should be keywords that indicate a particular strength of that collection. For example a collection could be of insects from Africa, but is particularly strong in butterflies from Zimbabwe.
In the database I would solve this by adding a strength flag to the property itself, so it's easy to differentiate between 'normal' (0) and 'strength' (1) keywords without the need for a different table. Wouldn't that be more logical for the schema too?
Regards,
Ruud