The Acme Company wants to construct a database to keep track of the company’s employees, departments, and projects as well as the employee’s dependents. Draw the entity-relationship model. The requirements collected to date to be modeled are: The company is organized into departments. Each department has a name, a number, and an employee who manages the department. A department controls a number of projects, each of which has a name, a number, and a start date but not all departments have projects assigned to them.We store each employee’s name, social security number, address, salary, sex, and birth date.Every employee is assigned to a department but may work on several projects, which are not necessarily under the control of the same department.We keep track of the number of hours per week that each employee works on each project.For most projects, a team of employees is assigned to work on the project while some employees are never assigned to a project.We also keep track of the direct supervisor of each employee.We want to keep track of the dependents of each employee, if they have any, for insurance purposes. We keep each dependent’s name, sex, birth date, and relationship to the employee.

Please check ER diagram on step 2

Answered: The Acme Company wants to construct a…

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter2: Database Design Fundamentals

Section: Chapter Questions

Problem 3TD

See similar textbooks

Related questions

Question

100%

The Acme Company wants to construct a database to keep track of the company’s employees, departments, and projects as well as the employee’s dependents. Draw the entity-relationship model. The requirements collected to date to be modeled are:

The company is organized into departments. Each department has a name, a number, and an employee who manages the department.
A department controls a number of projects, each of which has a name, a number, and a start date but not all departments have projects assigned to them.
We store each employee’s name, social security number, address, salary, sex, and birth date.
Every employee is assigned to a department but may work on several projects, which are not necessarily under the control of the same department.
We keep track of the number of hours per week that each employee works on each project.
For most projects, a team of employees is assigned to work on the project while some employees are never assigned to a project.
We also keep track of the direct supervisor of each employee.
We want to keep track of the dependents of each employee, if they have any, for insurance purposes. We keep each dependent’s name, sex, birth date, and relationship to the employee.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions