DB Desing Check
-
Hello my friend's I have a question in part of my DB,Please check it: ------------- ****operator idoperator . . ****role id Role title . . ****operator_role idoperator idRole ... ****capability idCapability title . . ****role_capability idCapability idRole .... ****operator_Capability idOperator idCapability value ----------------- is this true solution??? Best Regards
-
Hello my friend's I have a question in part of my DB,Please check it: ------------- ****operator idoperator . . ****role id Role title . . ****operator_role idoperator idRole ... ****capability idCapability title . . ****role_capability idCapability idRole .... ****operator_Capability idOperator idCapability value ----------------- is this true solution??? Best Regards
If I'm not mistaken you have the fifth normal form here. I see nothing wrong in that.
"The ones who care enough to do it right care too much to compromise." Matthew Faithfull
-
Hello my friend's I have a question in part of my DB,Please check it: ------------- ****operator idoperator . . ****role id Role title . . ****operator_role idoperator idRole ... ****capability idCapability title . . ****role_capability idCapability idRole .... ****operator_Capability idOperator idCapability value ----------------- is this true solution??? Best Regards
I'm hunting around for a negative comment - nope can't find one, oh wait underscores, hate underscores. Design is fine.
Never underestimate the power of human stupidity RAH
-
Hello my friend's I have a question in part of my DB,Please check it: ------------- ****operator idoperator . . ****role id Role title . . ****operator_role idoperator idRole ... ****capability idCapability title . . ****role_capability idCapability idRole .... ****operator_Capability idOperator idCapability value ----------------- is this true solution??? Best Regards