Greetings.

There is a table. There is a field. How to create a ternary relationship. Example: There is a table, there is a Field. Suppose in the Employees field there are 2 people who are married. You need to make a ternary relationship from the Employees field in the Employees field. Help. Or throw a link.

Help me please.

    1 answer 1

    Ternary relations, or multilateral relations, or connections of a high order (not to be confused with ternary operators) are resolved in a similar way, as are many-to-many connections. Only 2 tables of entities participate in the MM connection, and more than 2 tables in the multilateral ones. Those. it simply creates an intermediate table containing the primary keys of all the entities and the link attribute code. In your description, the typical connection is MM. only 2 entities are involved - employees, you want to describe their family ties. Add to the new table 2 links to the table of employees and the degree of kinship, we get a many-to-many two-way communication.

    To make communication multilateral, at least one more entity is needed, for example, the department in which employees work. Add another link to the table of departments in the link table, we get a multilateral link. You will also need to add types of people’s connections to departments in addition to the types of connections between people in the link types directory. Here , for example, shows an example of multilateral communication on the example of refueling.