Hi,
I have an address book database that keeps people in one table, occasions (meeting, birthday, etc) in a second table, and a lookup table, personOccasion, that signifies the occasions one is interested in with regard to a person. So, for example one may wish to know when one last had a meeting with a particular person. Following this pattern it would seem sensible to include a date field in the personOccasion table. However, what if one wants to be able to refer to a person's birthday? It would seem most logical to include date of birth as a field in the person table but doing so means that it cannot be properly reflected in the date field of the personOccasion table.
How do I get around the issue without having repeating groups in the person table?
I hope this is not too vague. Help much appreciated