I have a populated table like this:


I have been looking for problems in making good use of table information, and I have identified the follwing ones:

  • Someone could be assigned to a third or fourth activity.
  • There is no an unique identifier.
  • There is not a precise list of activites (for example, food preparation and cooking, transport and driving)
  • Searching logic can be messy and hard to maintain:

IF contribution == "cooking" OR contribution2 == "cooking" OR ... OR contributionN == "cooking"
Can you foresee another ones?

Thanks in advance.