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

nicktred

New Member
Joined
Sep 17, 2014
Messages
3
Gender
Male
HSC
2015
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

New Member
Joined
Mar 1, 2015
Messages
1
Gender
Male
HSC
2015
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.
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top