Can foreign in a table have duplicates

sree reddy · New User Joined: 20 Jul 2007 Posts: 27 Location: bangalore

Can Foreign Key in a table have duplicates

Thanks

dick scherrer · Posted: Tue Aug 18, 2009 1:50 am

Hello,

If there is a People table and a Department table and the dept column of the People table is defined as a foreign key constraint (i.e. a person may not be added with a non-existent department), there may surely more than one person in a given department. . .

Does this answer what you are looking for?

sree reddy · New User Joined: 20 Jul 2007 Posts: 27 Location: bangalore

Thanks

dick scherrer · Posted: Tue Aug 18, 2009 3:10 am

You're welcome

d