in Databases retagged by
356 views
1 vote
1 vote

Each Department is required to have atmost one employee as manager

My interpretation is 
for Department : Cardinality=1 Particiaption=0 
for Employee Cardinality=1 and Participation is what? (1 or 0)

Are they correct ?

in Databases retagged by
by
356 views

4 Comments

you cannot directly interpret anything from this information,

But if you want to conclude, Then each dept have at least one manager (They haven't said at least one employee)

so cardinality of dept is : N, participation can be 0

Each emp has to participate in at least and atmost 1 dept. Hence emp cardinality and participation = 1
1
1

how can cardinality of dept be N, it is mentioned each department is required to have atmost one manager"
so each department can participate with one employee at max, then cardinality has to be 1 right ?

0
0
They said at most one manager, not at most one employee. (I have interpreted this way)

I mean a dept has many employees among them 1 will be manager. (this statement makes sense)
2
2

@ashwin, one more thing if i have two entities one being STRONG say Person and other being WEAK say License then License will be on total participation.then cardinality and participation of License are 1 ;; and for Person participation =0 and cardinality is 1

are above statements correct ? 

0
0

Please log in or register to answer this question.