How can a Foreign Key and a Primary Key interact with each other?

In some database systems, A Foreign Key that is set on one column (the child column ) has to point to another column (the parent column ) that is indexed. The parent column could be a primary key, since a primary key creates an index. Primary keys also keep values in the parent column unique, which can ensure unique records in the parent column's table; having a unique key on the child column can further enforce unique data that links with the unique records in the parent column .