I'm struggling with a project set to me that involves allocating shifts to staff that work within an Event Venue. Basically, staff only work when there are events on.
Therefore, I have a database that contains tables showing:
- Shifts (for the above events)
The above are all linked by relationships in the database.
However, I am bewildered as to how I can have say 15 staff needed to do the same shift.
Elton John is playing on May 1st 2010 and requires 20 staff to work from 6pm until 11pm. What would be the best way to store/allocate this?