Forum Stats

  • 3,816,408 Users
  • 2,259,185 Discussions


Logical To Relational Engineer - Relation FK Attributes Name Not Retained

So this continuation to question recently posted.

I have two attributes in entity that were created through relations. This entity is intersecting entity to M:M relationship and thus has two parents. When I engineer to relational model 1. First FK attribute is created as column but datatype is not correct 2. There is additional column called {column} which matches datatype of first FK attribute. 3. Second FK attribute is created but has Name of {column}2.

Can't figure out why this is happening. Thanks