Hallo everyone,

Basicly i am new in database design. I've been designing a database
for my personal project application. i'm using Database design / ER
design software Toad Data Modelere Freeware.
the software devine a Foreign key (FK) and Primary Foreign Key (PFK).

If using Identifying Relationship between two tables then the Primary
Key (PK) on table one will identified as Primary Foreign Key(PFK) on
table two.

If using Non Identifying Relationship then the Primary Key (PK) on
table one will identified as Foreign Key(FK) on table two.

My question is what is the diference between Foreign Key and Primary
Foreign Key.

Thank you for your attention.
God Bless.