Database Modeling (Relationship Entity Model)

0

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?

    
asked by anonymous 25.11.2017 / 20:32

1 answer

0

There is no standard for modeling format, there is now missing identification of the relationship between entities, there are good practices to identify them as: group_id for a foreign key of the entity group or id_module for foreign key of the entity modulo .

    
25.11.2017 / 20:52