Page 1 of 1

can foreign key have same values ?

Posted: Mon Jan 02, 2006 10:56 pm
by dkshri_jain
can foreign key have same values ?

Posted: Mon Jan 02, 2006 11:18 pm
by timvw
Yes, you can have multiple records that all have the same value for an attribute that is a foreign key..

eg:

books (bookid, title, authorid)
(1, 'tim meets tiny', 2)
(2, 'tiny dumps tim', 2)

authors (authorid, name)
(2, 'Jezus')

Re: can foreign key have same values ?

Posted: Tue Jan 03, 2006 7:32 am
by Roja
dkshri_jain wrote:can foreign key have same values ?
Which database system? Did you try it?