Question
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 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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started