Type of paper: Essay

Topic: Employee, Workplace, Employment, Relationships, Management, Project, Model, Manager

Pages: 2

Words: 550

Published: 2021/01/05

New WowEssays Premium Database!

Find the biggest directory of over
1 million paper examples!

Other Details

Entity Relationship
Introduction
Entity relationship or ER is the relation between entities within a software system. An entity may be described as a group of related data. In the present case we have an employee table which has a relation with itself. A manager – who is also an employee – manages a group of employees. Such a relationship is called a recursive or unary relationship. We have been tasked with depicting and explaining such a relationship (Chen, 1976).

Model showing the following EMPLOLYEE relationships:

An employee must have a manager
N

Manages

1

A manager may have at least 1 employee

N

Manages

1

A manager must have at least 1 employee

1
Manages
1

A manager may have no employees

Manages
1

Model showing the following PROJECT – EMPLOYEE relationships

One employee can participate in many projects
1 N

One project can have many employees

N 1

Questions

Which type of entity will help you model this many-to-many relationship?
M N

Is it possible for a project to have no employees assigned, and how would you model that possibility?

It would not be possible for a project to have no employees in a real life situation. This situation could be modelled in a database by showing that a project must have at least 1 employee. This would be modelled as under:
N 1

Is it possible for an employee to be unassigned to any project, and how would you model that possibility?

It is not possible for an employee to be unassigned to any project since a project must have at least 1 employee. This eventuality would be prevented by the PROJECT-ID FK in the employee table. The relationship would be modelled as under:
N 1

References

Chen, Peter (March 1976) "The Entity-Relationship Model - Toward a Unified View of Data" ACM Transactions on Database Systems 1 (1): 9–36 doi:10.1145/320434.320440

Cite this page
Choose cite format:
  • APA
  • MLA
  • Harvard
  • Vancouver
  • Chicago
  • ASA
  • IEEE
  • AMA
WePapers. (2021, January, 05) Entity Relationship Essays Example. Retrieved October 16, 2021, from https://www.wepapers.com/samples/entity-relationship-essays-example/
"Entity Relationship Essays Example." WePapers, 05 Jan. 2021, https://www.wepapers.com/samples/entity-relationship-essays-example/. Accessed 16 October 2021.
WePapers. 2021. Entity Relationship Essays Example., viewed October 16 2021, <https://www.wepapers.com/samples/entity-relationship-essays-example/>
WePapers. Entity Relationship Essays Example. [Internet]. January 2021. [Accessed October 16, 2021]. Available from: https://www.wepapers.com/samples/entity-relationship-essays-example/
"Entity Relationship Essays Example." WePapers, Jan 05, 2021. Accessed October 16, 2021. https://www.wepapers.com/samples/entity-relationship-essays-example/
WePapers. 2021. "Entity Relationship Essays Example." Free Essay Examples - WePapers.com. Retrieved October 16, 2021. (https://www.wepapers.com/samples/entity-relationship-essays-example/).
"Entity Relationship Essays Example," Free Essay Examples - WePapers.com, 05-Jan-2021. [Online]. Available: https://www.wepapers.com/samples/entity-relationship-essays-example/. [Accessed: 16-Oct-2021].
Entity Relationship Essays Example. Free Essay Examples - WePapers.com. https://www.wepapers.com/samples/entity-relationship-essays-example/. Published Jan 05, 2021. Accessed October 16, 2021.
Copy

Share with friends using:

Please remember that this paper is open-access and other students can use it too.

If you need an original paper created exclusively for you, hire one of our brilliant writers!

GET UNIQUE PAPER
Related Premium Essays
Contact us
Chat now