design E-R diagram of :

Question

Each employee is assigned to a project work at only one location for that project, but can be at a different location for a different project. At a given location, an employee works on only one project. At a particular location, there can be many employees assigned to a given project.

--------------------------------------------------------------------------------------------------------

According to me----

Employee and project will be 2 entities..

(1,N)  between employee and location..

(0,N) between project and employee.. as it is written "At a particular location, there can be many employees assigned to a given project." and it is not mentioned that every project is  held by a employee .

Am i right..??

Answer 1

I think u are right because according to question a employee can work at many location so one employee can have n location.