Relative Content

Tag Archive for databasedatabase-designforeign-keysrelational-databasedatabase-schema

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.