Is it necessary for a foreign key to be a primary key in another table? Why? I am new to database implementation. I want to know if it is necessary for a foreign key to be primary key of another table.
Foreign key is not unique - it may have duplicate entries. If it must be primary key of another table then why it is necessary?
I think any column can be a foreign key because you can put condition at any column.
The referencing column may not be unique, as you point out. If the referenced column is also not unique, you have created a many-to-many relationship, which is a right pain to implement and can cause problems maintaining data integrity.
For example, I have two rows in table 1 with the same value in the referenced column. I also have two rows in table 2 with the same value in the referencing column. I then change one of the rows in table 1; which rows in table 2 should also be updated?
If the referenced column is unique, but is not the primary key, then your table may be in an &quot;abnormal form&quot; and the additional unique column may be redundant. The test for this is to ask yourself two questions:

If I make the unique column(s) the new primary key, and drop the old primary key column(s), do I lose any data about the entity? If not, your table is in an abnormal form.
Can the unique column(s) change during the lifespan of the entity? If not, then the column(s) constitute a key candidate key.

In practice, there are sometimes very good reasons for denormalizing tables, but these must be considered carefully on a case-by-case basis.
Note that it is possible to reference a unique non-primary-key column or column group. However, since conceptually the primary key is &quot;The&quot; canonical identifier for the row, it makes more sense to reference the primary key.