title: does foreign key always reference to a unique key in another table?
body: <p>Is it not possible that foreign key(single column) in a child table references to a parent key which has some duplicate values? </p>