Using Microsoft Word, Excel or Visio, create a list of attributes required to ca

Question

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?

Explanation / Answer

Employee Information

Project Information

                Employee Work History

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.