0

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
6
Views
5 Years
Discussion Span
Last Post by pritaeas
0

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

1

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

0

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

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.