Entity Relationship Essays Example
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
A manager may have at least 1 employee
A manager must have at least 1 employee
A manager may have no employees
Model showing the following PROJECT – EMPLOYEE relationships
One employee can participate in many projects
One project can have many employees
Which type of entity will help you model this many-to-many relationship?
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:
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:
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
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!
- Paper Writer
- Write My Paper For Me
- Paper Writing Help
- Buy A Research Paper
- Cheap Research Papers For Sale
- Pay For A Research Paper
- College Essay Writing Services
- College Essays For Sale
- Write My College Essay
- Pay For An Essay
- Research Paper Editor
- Do My Homework For Me
- Buy College Essays
- Do My Essay For Me
- Write My Essay For Me
- Cheap Essay Writer
- Argumentative Essay Writer
- Buy An Essay
- Essay Writing Help
- College Essay Writing Help
- Custom Essay Writing
- Case Study Writing Services
- Case Study Writing Help
- Essay Writing Service