Particular employee who manages the department

Assignment Help Operation Management

Reference no: EM131709049

After the requirements collection and analysis phase, the database designers stated the following description of the part of the company to be represented in the database. Please develop an E-R diagram to represent the conceptual model.

1. The company is organized into departments. Each department has a unique name, a unique number, and a particular employee who manages the department. We keep track of the start date when that employee began managing the department. A department may have several locations.

2. A department controls a number of projects, each of which has a unique name, a unique number, and a single location

3. We store each employee's name, social security number, address, salary, gender, and birth date. An employee is assigned to one department but may work on several projects, which are not necessarily controlled by the same department. We keep track of the number of hours per week that an employee works on each project. We also keep track of the direct supervisor of each employee.

4. We want to keep track of the dependents of each employee for insurance purposes. We keep each dependent's first name, gender, birth date, and relationship to that employee.

Reference no: EM131709049

Questions Cloud

Budget allocations from traditional to digital-social media : Explain some of the reasons marketing are shifting their budget allocations from traditional to digital and social media.

Are trash receptacles easy to gain access to : Are trash receptacles easy to gain access to?Are documents Shredded before being discarded?Are areas where trash is stored easily accessable?

How much the entropy of ice change as it melts into water : The latent heat of fusion of water at 0oC is 335 kJ/kg. How much does the entropy of 1 kg of ice change as it melts into water

Assisted living and a hospice care facility : Describe the roles and responsibilities of the administration in a Assisted living and a hospice care facility

Particular employee who manages the department : The company is organized into departments. Each department has a unique name, a unique number, and a particular employee who manages the department.

Identify brand problems of trader joe : Identify brand problems of Trader Joe's (or any grocery store) and solve it through IMC(Integrated marketing Campaign). List the points and explain it.

Discuss a general audience of adults : Choose a topic that you are interested in. Pretend that you are preparing it for a general audience of adults

Analyze the main ways in which the massive poverty of nation : From the case study Earthquake in Haiti, analyze the main ways in which the massive poverty of this nation hindered response and recovery efforts.

How would this knowledge help you to be a better risk : How would you determine which paradigm waves best describes that part of the world? How would this knowledge help you to be a better risk manager?

User Account

All Pages