Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
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. . .