Can one to one links consist of a link between a foreign and a primary key? (1 Viewer)

[nicktred]

Hi guys, I have a test for IPT tomorrow and was wondering if one to one links can consist of a link between a foreign and a primary key in a schema diagram.

Thanks in advance

 

[fluze]

Well, yes. A primary key that is another table in a DBMS is considered a secondary/foreign key. One-to-one is basically when the secondary key may be something like a unique form of identification, such as StudentID or the like.

PS: Probably a bit late, felt bad that nobody told you.