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.
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.
Chapter1: Overview Of Database Concepts
Section: Chapter Questions
Problem 3RQ
Related questions
Question
100%
The Acme Company wants to construct a
- 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
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
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.Recommended textbooks for you