611 views
1 votes
1 votes

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.

1 Answer

0 votes
0 votes

basically this can be broken down as . 

employee works at on project . so always we make noun and object as entity so here project and employee can be entity where as verb is the relationship . which is works at . so i think this can be the er diagram .

Related questions

0 votes
0 votes
0 answers
1
3 votes
3 votes
3 answers
2
CKgurav asked Jan 1, 2016
985 views
how many tables will get generated for following E-RI believe an answer is 3.2 tables for 2 different multivalued attributes and one for entity "Dept.".
1 votes
1 votes
2 answers
3
himanich asked Jun 22, 2016
2,453 views
Which of the following are true for relational database?Number of rows is cardinality, number of columns is degreeTuple is an entity, column is a relationRelation is an e...
0 votes
0 votes
0 answers
4
Deepalitrapti asked Aug 16, 2018
169 views