Having a loop in a relationship ER modelling

Question

Using Chen's notation on an entity relationship model, for database design. Is this the correct way to illustrate the following relation. 'Many employees report to one employee':

enter image description here

score 0 · Answer 1 · answered Apr 24 '13 at 07:12

0

You dont need the diamond. You can have the direct relationship. Unless the relationship itself has attributes, the diamond is not used.

answered Apr 24 '13 at 07:12

Arjun Rao

677
4
15

This is from a school past paper and the diamond was there so i think its meant to be used. Is this still correct though? – joker Apr 24 '13 at 07:14

score 0 · Accepted Answer · edited May 23 '17 at 10:32

0

I think the below image would be more approapraiate

enter image description here

E-R Diagrams

DATA MODEL

STACK SIMILAR QUESTION

edited May 23 '17 at 10:32

Community

1
1

answered May 12 '13 at 13:22

Prahalad Gaggar

11,389
16
53
71

Having a loop in a relationship ER modelling

2 Answers2