5.3 Exercise: Software consulting firm

A software consulting firm wishes to keep the following data for an employee and costing database: 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.