Has anybody ever dealt with a data model where a parent group can have varying levels of children? I am having a hard time wrapping my head around developing a data model for an active directory, where a parent security group could have children that are users and/or children groups that might have more groups and/or users underneath them. I need to be able to score individual users and aggregate them up through the hierarchy in a way that is fluid. Here is a sample of the kind of relationship I am describing:
