Good afternoon,
In the image below you have the modeling of the following problem. I have users where they will belong to modules (physical module, portuguese module, chemical module) are 3 modules in total.UM and only UM (1) of modules can contain 1 to n groups, these groups are formed by users and each group contains only 1 Administrator.
In the user table I use an attribute to tell if the user is ADM of some group.
My question is regarding the modeling I did, realize that it is circular. Does anyone have a better way to model this problem?