hi all, my first question here and hoping to get some answers. i am working on a project (similar to some I've seen here) , and need some advice on modeling my data ... here is the scenario:
1 - a person has membership and is renewal is requested each year otherwise it's void. membership is approved by one or more group leaders, once approved , it has to be paid to become active.
2 - a person can be member of one or more groups
3 - a member can have a role in a given group for a period of time (which need to be tracked both ways)
4 - groups can have belong to a hierarchy (i.e.: city groups are under regional groups which are under a national group )
5 - each group elects n members to occupy positions for a period of time ... this needs to be tracked (same as Q3) ... they can be removed/replaced for given reasons (also to be tracked).
how would you model this , knowing that groups can have different requirements (properties are different depending on the scope of the group) ... your thoughts are really appreciated.
