1,476 views
1 votes
1 votes
A project consists of minimum of two employee and maximum of 30 employee. Every employee need not participate into some projects, but if it does then it can be maximum of 4 projects.

Represent the above information in ER diagram, and show the following

1) Which entity in Partial participation and which is in total participation?

2) Represent the cardinality ratio of each entity.

2 Answers

Best answer
1 votes
1 votes

1) project is total participation whereas employee is partial participation..

2) (0,4) for employee and (1,30) for project..

selected by
0 votes
0 votes
  1. entity employee is partial participation and project is total participation.
  2.  As employee is partial participation then its possible that none of them are forming relationships hence the minimum can be 0 and max is given in question as 4. So, (0,4) is correct for employee. Now, as project is total participation, atleast we would be having 1 relationship so min is 1 and according the question 30 is max. So (1,30). Please correct me if I am wrong.

Related questions

2 votes
2 votes
3 answers
3
daksirp asked Apr 23, 2022
1,313 views
What is the cardinality of this relationship? is m-n cardinality correct? if not, why?
1 votes
1 votes
0 answers
4
Salazar asked Dec 27, 2017
335 views
Each Department is required to have atmost one employee as managerMy interpretation is for Department : Cardinality=1 Particiaption=0 for Employee Cardinality=1 and Parti...