This is my first big database design and I may be in over my head. So, I thought I'd ask around before i get too far. I've done some research on issue tracker databases but I'm having some trouble changing them to suit my needs.

I have a list of Funds that are processed daily. And, I have a list of accountants.

I need to have a record of what accountants are assigned to which funds. I also need to know how long they have been assigned. There are cases with part time employees where two accountant are assigned. The part time employees swap fund depending on who has off that day.

I also need to record which accountants actually did each fund every day in case of illness, etc... There are cases when a fund is covered only in the morning or afternoon.

I'll take any help. Please

Thank You