How to implement ONE-TO-MANY in a database

Admin 1
Viewed 27847

I want to implement one-to-many concept in my application. This is the scenario: I have two tables

(i). Person(ID, NAME, AGE, DEPT)
(ii). Person Responsibilities(ID, RESP'S)

One person may have more than one responsibility. How shall I implement a 1-n relationship here? Actually, I don't understand the correct concepts for this.

Any suggestions or links to understand this concept would be appreciated.

rdbms database-design foreign-keys
3 Answers

I would simply say that the backward relation of a one-to-many is a many-to-one (which is a foreign key). Thus, to implement a one-to-many, you have to use a foreign key on the related table.

user_15293460
Related