I created a Parent logical entity with a single attribute, which is its Unique Identifier.
Then I added a “empty” Child entity, and then added an identifying relationship to Parent.
At this point I expected the Unique Identifier of Parent to be “copied” to Child, but it wasn’t.
Thinking the attribute would be added when converted to the physical model (Oracle 11g), I tried a simple conversion, but the attribute wasn’t added there either.
If I add an equivalent relationship in the physical model, then the parent PK is automatically added to the Child table.
So how is one supposed to model the equivalent of a PK/FK relationship in the logical model such that it properly generates the PK/FK once converted to the physical model?
I’d appreciate any insights on this matter, as I’m currently stumped. I can’t imagine there isn’t some way to do this automatically, because otherwise it would reduce the logical modeling usefulness in my mind. Or am I completely missing something?
Update: After watching the flash movie on Logical Modeling 1 again, I tried again, this time making sure I create the PUIs before adding the relationships, and also naming the PUIs differently in each entity. Then the PFK where indeed added to the physical child tables. So I guess it was user error (what I suspected :), yet it’s a bit confusing that creation order may matter.
Message was edited by: ddevienne