Modeling the relationship of employees and managers

Assignment Help Operation Management

Reference no: EM131232445

You are modeling the relationship of employees and managers in your organization. One possibility is to show a unary or recursive relationship on the EMPLOYEE entity. How would you model the cardinality of the unary relationship to indicate that an employee has one manager and a manager may have many employees? Draw the model to show that an employee must have a manager. Now draw the model to show that a manager must have at least one employee. What happens if a manager has only one employee assigned, and then that employee is reassigned? Draw the relationship with cardinalities to indicate that a manager may have no employees.

Your organization asks you to create a data model for employees participating in projects. One employee can participate in many projects. One project can have many employees assigned. Your stakeholders want to know the role of each employee on a project. Address the following questions in your paper:

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?

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

Deliver this modeling assignment in a 2- to 3-page paper that includes your models and your responses to the questions provided herein. APA format.

Reference no: EM131232445

Questions Cloud

Example of a task in function : Describe the functions carried out by healthcare managers, and give an example of a task in each function.

Leaders in a health care organization : Why is important to have leaders in a health care organization?

Which variable is the independent variable : You are consulting for a large real estate firm. You have been asked to construct a model that can predict listing prices based on square footages for homes in the city you've been researching. You have data on square footages and listing prices..

Write the structure of the rearranged carbocation : Each of the following carbocations has the potential to rearrange to a more stable one. Write the structure of the rearranged carbocation and use curved arrows to show how it is formedCopy and paste your question here...

Modeling the relationship of employees and managers : You are modeling the relationship of employees and managers in your organization. One possibility is to show a unary or recursive relationship on the EMPLOYEE entity. Which type of entity will help you model this many-to-many relationship? Is it poss..

Describe overall process of submitting a health information : Analyze a few situations that can occur if the critical sections are not well identified. Describe the overall process of submitting a health information privacy complaint to the OCR.

Actionly invades consumer privacy by taking data : Argue for or against the following statement: Actionly invades consumer privacy by taking data from different websites such as Twitter and Flickr without the consent of the customer who posted the information.

Performance of the coca cola company : How the changing competitive landscape affecting the performance of the coca cola company?

Efficiency of the overall healthcare system : 1. What should (can) senior health policy makers do to improve the efficiency of the overall healthcare system? 2. What can individual healthcare professionals do to improve the operational efficiency of their own organizations?

User Account

All Pages