About table of accesses in ER diagram of the following example, If I know Name of a Project and I want to know all Code of Employee entity which contribute to this project, I need to access only to Partecipation Relationship or to both Partecipation Relationship and Employee entity?
input: Name of Project:
output: list Codes of all employee which contribute to project
I'm projecting database for school and in this step It's not necessary to think what will be contained in this participation table because this one is a part of model logic, which will translate afterwards.
Access table is made in ER schema, not in logic Schema