Member Avatar for sasikrishnasamy

hi,
I am having doubt in peter_budo 's Mvc tutorial, in datbase design he has separate table for group mapping,
Even we can add seperate feild (like group) in user table itself to acheive the same result, Is there any advantage in seperate that, Pls some one guide me.
Sorry if anything wrong,

Edited by sasikrishnasamy
  • 2 Contributors
  • 5 Replies
  • 159 Views
  • 11 Hours Discussion Span
  • Latest Post Latest Post by pritaeas
Member Avatar for pritaeas

It's probably a normalization. Can you please provide some additional info, like a link to the tutorial you mentioned.

Member Avatar for pritaeas

Yes, it is because of normalization. In this setup, a user can belong to multiple groups. By adding a column, as you suggested, this is not possible. It would be one user in one group.

Edited by pritaeas
Member Avatar for sasikrishnasamy

thank a lot pritaeas,
For example if user belongs to staff and admin groups which group rights he will get
once again thanks

Edited by sasikrishnasamy
Member Avatar for pritaeas

The database will just say he has both, what you do with it in your code is up to you.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.