How to interpret ternary relationship? I have tried to search online on how to interpret these ternary relationships but haven't found any clear answer. Since I don't understand how to interpret it I am having trouble changing it into relations as well. In an example like this:



How exactly would I interpret this? For instance:

The line with an arrow going into Works_in3 from the Employee entity, is that pointing to the Departments entity or the Locations entity? So is it implying that an Employee can only work in one department or is it implying that an employee can only work in one location or does it imply both?
This looks to me that an employee works in at department at a location since a point in time.  I don’t recognise the diagram type as an ERD so I can’t tell what type of relationships they are but I expect that they are one to many. i.e. the works_in3 table is a link table to facilitate a many to many relationship of employee and department. As for location I expect this is where the employee worked in this department, again representing a many to many relationships, as one location could house many employees performing many roles for departments. But that’s just my opinion.