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