A software consulting firm wishes to keep the following data for an employee and costing database:
- the employee number
- the employee name
- the employee address
- salary
- the current job code
- job history (job promotion code + year)
- office location
- telephone number
- project number
- the project name
- the task number
- a task name
- project budget
- a task expendature to date
- department number
- department name

There are none, one or mor ejob promotion code/year entries per employee, The office location uniquely depends on The telephone number, and There may be more than one employee using The same telephone and wining one telephone in The one office. The Tasks are numbered uniquely only within each project. An employee may be concurrently assigned to more than one project and task, but belongs to one department. Reduce this data to third normal form.