erd relationship types

Question

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

Posted 21-May-12 22:51pm

mido_h_89

Add a Solution

1 solution

Add a Solution

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

Wendelius · Answer 1 · 2012-05-22T10:11:00

Solution 1

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)

managementboard
---------------
id
name
year

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

person
------
managementboardid (foreign  key to managementboard)
name

then it would be a one-to-many relationship.

Posted 22-May-12 10:11am

Wendelius

Comments

Espen Harlinn 22-May-12 18:12pm

5'ed!

Wendelius 23-May-12 0:06am

Thanks Espen

Prasad_Kulkarni 23-May-12 0:25am

Nice +5!

erd relationship types

1 solution

Solution 1

Add your solution here

Preview 0

erd relationship types

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us