[AccessD] Chore Schedule

David McAfee davidmcafee at gmail.com
Tue Mar 25 11:14:56 CDT 2014


So, I'm playing around with the idea of making a database for a task/chore
schedule for our 3 kids.
Right now they rotate between dishes, trash (inside and taking it to the
curb) and a free week.

They all have busy schedules with school, work, extra curricular activities
and whatever else they might have time for. So a need may arise for one
person to "request" a trade of a day or the complete week for another
person. The other person would, obviously, have to approve it.

I having a bit of trouble coming up with the table schema.

Obviously we would have a table of tasks/chores:

tblTask
TaskID (AN, PK, INT)
Task (Varchar(25))

Sould the Free week be listed as a task for simplicity?


I also need a person talbe
tblPerson
PersonID
Person

Would a junction table handle it all?
tblPersonTaskJunct
PKID
TaskID
PersonID
WeekNumber ? DayNumber?

Would I need another table for the trades?

Any ideas?

Thanks,
David


More information about the AccessD mailing list