Hi All,

I have a problem/don't know the solution... and it is

User has many Projects, Project has many users, and user has multiple roles for a Project.

Eg:

Ram, John are multi skilled persons.

Ram and John are associated with many Projects in a company

Project A has many Users (Ram, Shyam, John, Ryan)

In Project A, Ram takes the roles as 'Configuration Manager and Network Manager' and John takes the roles as 'Developer and System Administer'.

In Project B, Ram takes roles of 'Developer and System Administer' and Ryan takes roles as 'Configuration Manager and Network Manager'.

In Project C, all users are developers.

So we have three tables User, Project and Role

Users are Ram, Shyam, John and Ryan
Projects are Project A, Project B and Project C
Roles are Developer, System Administrator, Configuration manager and Network Manager.

How do we design this situation.

Thanks,
Uday.

With a 4th table: UserProjectRoles (UserId, ProjectId, RoleId), with all 2 columns being part of the primary key.