normalization again

2013-05-01 Thread Gary Jeurink
Here I am again with a rookie question. The system I am trying to develop will bill students (1)-team once-per-month.. could be twice a week up to 4-times per week depending on level. So an attendance record would be . date/which month/athleteID with a Boolean attended/absent. Then (2) there are re

RE: normalization

2013-04-23 Thread Gary Jeurink
--Original Message- From: Ted Roche [mailto:tedro...@gmail.com] Sent: Monday, April 22, 2013 1:16 PM To: profox@leafe.com Subject: Re: normalization On Mon, Apr 22, 2013 at 11:54 AM, Gary Jeurink wrote: > Every time I think I understand something a new wrinkle throws me for a > loop. I hav

Re: normalization

2013-04-22 Thread Ted Roche
On Mon, Apr 22, 2013 at 11:54 AM, Gary Jeurink wrote: > Every time I think I understand something a new wrinkle throws me for a > loop. I have a client table (family to bill). I have a student table > (families have multiple kids) and a classes table (class with the students > enrolled). I made an

RE: normalization

2013-04-22 Thread Tracy Pearson
Jean MAURICE wrote on 2013-04-22: > Le 22/04/2013 17:54, Gary Jeurink a écrit : > I made an intermediate table spots (classID, studentID, > clientID) > my two cents : just add a date field 'day' in this table and insert one line per > student per classe and per day. You'll be able to count th

Re: normalization

2013-04-22 Thread Jean MAURICE
Le 22/04/2013 17:54, Gary Jeurink a écrit : I made an intermediate table spots (classID, studentID, clientID) my two cents : just add a date field 'day' in this table and insert one line per student per classe and per day. You'll be able to count the number of days in each class for each studen

normalization

2013-04-22 Thread Gary Jeurink
Every time I think I understand something a new wrinkle throws me for a loop. I have a client table (family to bill). I have a student table (families have multiple kids) and a classes table (class with the students enrolled). I made an intermediate table spots (classID, studentID, clientID). This