AnsweredAssumed Answered

Graph design validation please

Question asked by Cécile on Nov 13, 2018
Latest reply on Nov 13, 2018 by Cécile

I think it is right yet at the same time I wonder if the assignment table is not overkill?

 

My project has many functional roles (technician, lead, primary contact, etc) Most of these roles can be assigned to more than one person on a given project and a person may be assigned different roles.

So I have a 4 table chain. Project - Roles - Assignments - Contacts.

 

assign.png

Outcomes