2 ms·
> What AI do you need? You map your tables to objects and relationships between objects via FK relationships. That is only true in a one-to-many entity relatio
by sergiosgc 9y ago
> What AI do you need? You map your tables to objects and relationships between objects via FK relationships.
That is only true in a one-to-many entity relationship (and even so, it is debatable). A one-to-one relationship can be modeled in the two objects, in one of them, or delegated to a third entity. A many-to-many entity relationship can also be handled, in OO, in various different ways. Idem for a ternary relationship or, basically any higher order relation between objects.
This is known, borrowing a term from electrical engineering, as an impedance mismatch between the two models, and it's not an easy problem by any measure.