Ternary connection in MC Access - MS Access
Welcome.
There is a table. There is a field. How to create a ternary connection for it. Example: There is a table, there is a Field. Let's say in the Employees field there are 2 people who are married. You need to make a ternary connection from the Employees field to the Employees field. Help. Or throw a link.
Help please.
1 answers
Ternary relations, or multi-way relations, or high-order relations (not to be confused with ternary operators) are resolved in a similar way as many-to-many relations. Only 2 entity tables are involved in the M-M relationship, and more than 2 in the multi - party ones. That is, an intermediate table is simply created that contains the primary keys of all entities and the link attribute code. Your description is a typical M-M relationship, since only 2 entities are involved-employees, you want to describe their kinship relationships. Adding it in the new table 2, links to the table of employees and the degree of kinship, we get a two-way many-to-many relationship.
In order for the relationship to become multi-faceted, you need at least one more entity, such as the department where the employees work. Add another link to the table of departments to the table of relations, and we get a multi-way connection. You will also need to add the types of people-to-department relationships to the link types directory in addition to the types of people-to-people relationships. Here, for example, is shown an example of a multi-party connection using the example of a gas station.