A better database design on SQL Server?
In SQL Server, I have got to design a User table. It should have a UserID (int), a RoleID (int) and a UserName (nvarchar(255)).

A user can be assigned with a name but possibly multiple roles so a UserId may correspond to multiple RoleIDs. This makes it difficult to assign primary key to UserID as UserID may duplicate.

Is there any better design other than breaking it up into multiple tables?

Thanks

Cheers,
Alex


A better database design on SQL Server?
===

In SQL Server, I have got to design a User table. It should have a UserID (int), a RoleID (int) and a UserName (nvarchar(255)).

A user can be assigned with a name but possibly multiple roles so a UserId may correspond to multiple RoleIDs. This makes it difficult to assign primary key to UserID as UserID may duplicate.

Is there any better design other than breaking it up into multiple tables?

Thanks

Cheers,
Alex

