Click here to Skip to main content
15,042,397 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
hello everybody

when designing the erd , let's consider the following case :
we have two entities : (management_board) and (person) , a person can't be a member in more than one management board at once , but he can be a member in management_board_1 in 2011 , and then a member in management_board_2 in 2012 , so , the relation between entities : (management_board) and (person) , is it (one to many) or (many to many) ?

thanks in advance ...

1 solution

If the management board is one entity and contains the management board and the year, for example (name+year is unique, id is primary key)

and the person references a single management board, for example (managementboardid+name is unique)

managementboardid (foreign  key to managementboard)

then it would be a one-to-many relationship.
Espen Harlinn 22-May-12 18:12pm
Wendelius 23-May-12 0:06am
Thanks Espen
Prasad_Kulkarni 23-May-12 0:25am
Nice +5!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900