double relationships can exist, e.g.

take a
HumanResourceTable
id_person
name
department


ApplicationTable
id_application
id_person_technical
id_person_accountant

where both id_person~ reference HumanResourceTable

I did this in the past for sybase and oracle