Primary key column and duplicate foreign key value

Question

Please help me Is it possible to insert unique value in Primary key column and duplicate corresponding value in foreign key column table? I need to insert unique value in Primary key column and duplicate corresponding value in foreign key column. Like a field wih S01 S02 S03 in primary key column and many S01  S01 in foreign key column table

Biswa Pujarini Mohapatra · Answer

Yes it is possible that is the basic use of primary and foreign key generally if you make a column as primary key it will not allow you to insert duplicate

Bidyasagar Mishra · Answer

Primary key column will never allow you to insert duplicate records. Also one thing you should always remind we cant create more than one primary key column in a table

Manchana Shrestha · Answer

Thank you so much.

Primary key column and duplicate foreign key value

Please help me, Is it possible to insert unique value in Primary key column and duplicate corresponding value in foreign key column table?