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 · Accepted 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.