How to model exclusive relation in relational database?
Let there be 3 tables: A
, B
, C
.
A row in A
may be associated to a row in B
, or it may be associated to a row in C
, but it must not be associated to both B
and C
.
In other words, the association is an exclusive-or, one-to-one.