Roster Type Arrangement

I'm looking for some ideas to best do this project i've taken on.


We have a group of about 50 people and we want to assign them, semi randomly to a duty. There are about 15 duties a day.

Ideally, they wouldn't receive an individual duty for the majority of their duties and they'd only have one duty every 3 or so days.

Additionally, each person has preferences, determining which days they cannot have a certain afternoon duty.

What would be the best way to attack this?

(I was thinking of a Access DB / something that I can use sql with :p)

Of course there'd need to be lists of the people, tracking their total duties and frequency.

Any ideas?


Thanks