The Office Administrator currently has a Spreadsheet to track which office is assigned to which employee. Since an employees title determines the type of office, the Office Administrator also tracks the employees title. However, there can be an employee that is hired but has yet to be assigned to an office.

Additional Business Rules:

1) More than one person can have the same title. An employee can have more than one title.

2) Every employee must be assigned to a specific department.

3) The College of Technology currently has rooms in multiple buildings.

4) More than one employee can be assigned to the same room/office.

5) Some rooms are used by multiple departments.

6) An employee can be given more than one office/room.

7) There is a need to track Employee and Office Status.