Reference no: EM132171768
Using Microsoft Word, Excel or Visio, create a list of attributes required to capture data in the entity using the information provided below.
Specify the attributes required to capture the data for employees working on software projects within the company.
Employees from many departments work on projects. Data should be recorded for the length of time an employee has spent on a given project by date and hours worked.
The data model should ensure the following questions can be answered:
- Which employees are working on a particular project?
- How many hours have employees worked on a certain project?
- How many active projects exist?
- Which software projects are completed, and on what date?
- In which departments do the employees work in for all projects starting in 2016?