5.3 Exercise: Software consulting firm
A software consulting firm wishes to keep the following data for an employee
and costing database:
- employee number
- employee name
- employee address
- salary
- current job code
- job history (job promotion code + year)
- office location
- telephone number
- project number
- project name
- task number
- task name
- project budget
- task expenditure to date
- department number
- department name
There are none, one or more job 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 more than one telephone
in the one office. 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.
Write the relations into a text editor and normalise them. When you are finished
ask a lecturer or demonstrator to check your result.
Index