0

i would like to know how to add PK to cross - reference table which is created from converting Conceptual Model to Physical Model and associate it with other table as FK.

Conceptual Model

Conceptual Model

Physical Model

Physical Model

Expected Result

Physical Model

  • Job Applications Table : PK ja_id(int)
  • Applications Table : FK ja_id(int)

I think i've described my problem clear enough :)

Thanks for help !

xyz
  • 2,277
  • 2
  • 25
  • 41
  • I guess the answer you propose is the logical consequence of your description: first you said "Job Applications" is an association; but then you added "... but it has an identity, other than the couple of extremities of the association". – pascal Dec 05 '11 at 04:46
  • That's an awful lot of ID numbers for a conceptual model. – Mike Sherrill 'Cat Recall' Dec 06 '11 at 14:49

1 Answers1

0

Workaround for my question is shown in attached pics.

Conceptual Model

Conceptual Model

** Physical Model**

Physical Model

xyz
  • 2,277
  • 2
  • 25
  • 41