[AccessD] Chore Schedule

David, a trivial seeming (but not so trivial) systen. I don't quite see how
to implement the free week concept, they can't all take their free week at
same time. And what happens if there are more chores than children, how is
this scalable? You cannot create weeks.

Thorny, I have tried already looking at it from a number of ways for about
45 minutes and actually gave up.

Could you think of a point based system, suppose trash is lighter work than
dishes, gets a value of 5 and dishes 10. The goal is to hit a certain
number of points before earning a free week. But even this is hard to
scale:  how do you ensure accountability (record and respond to defects and
half done chores), facilitate trading, add seasonal work. Worse, I STILL
had the problem when more than one kid wanted to use their free week or
banked more than one. So free weeks ought to be pre assigned, but how is
that gonna fit with everyone's busy schedule?

Good Luck! , it will be interesting to see how simple and elegant others'
solutions can be.

 On Mar 25, 2014 12:16 PM, "David McAfee" <davidmcafee at gmail.com> wrote:

> 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
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>