var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I have a question concerning setting up tables. I'm wondering why I would set up the tables in one way rather than the other way.
Users Roles Group
------ ------ -------
pk)UserID pk)UserID pk)GroupID
UserName pk)GroupID GroupName
Which one of these designs would be most efficient and why?
Can someone help me on this one.
Example 2 doesn't seem to make sense to me: each group can only have 1 user in it? But if you meant to make UserID part of a composite PK with GroupID, then it still isn't good because GroupName is then denormalised.
So Example 1 is the way to go.
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors