data structure question

Author: Gary Jeurink

Posted: 2013-12-18 at 14:40:41

I'm trying to throw together a gymnastics school in a cloud that includes

skill tracking, an attendance and billing system. Since I don't have

accounting experience, I need help with the invoice structure so I have

questions.

Tables involved as I have progressed so far: classes, students,

clients(person billed), spots(current list of students per class), and

sessions

A session can be 4-weeks, 5-weeks or 11-weeks (summer option where a

customer may pick which of the 11 weeks they want to attend).

In the end I want to take roll per class. classID, studentID, sessionID,

(date?). This is where I get hazy. Where do I put attended/absent fields

when it will be class/session/date related.

Class-1 could meets Mondays at 4pm. (Labor day-off..1-less week) Class-2

could meet up to 4-times per week. A student could be enrolled in more than

1-class (discount-eligible). Client-12 may have multiple children (also

discount eligible).

I'm thinking my invoice to bill clients for a session, will be the same

table I take enrollment in. It gets complicated as we try to allow

occasional make-ups when other classes have room to accommodate an extra

student. We also allow a student to jump in for the last week of a session

as openings permit and we would pro-rate that session so they only pay from

their start and forward. We have waiting lists for most of our classes

(which means a scheduled make-up is rare).

My overall goal is to take attendance and note skill achievements with

i-pads or equivalent device out in the gym and let our office manage the

billing. A cloud would be ideal where parents could check student progress

and interact with notes to and from coaches and so on.

I'm not afraid of doing the work but I'm not sure how to proceed and I don't

want to make a big fluffy data records that never get used.

Gary Jeurink

--- StripMime Report -- processed MIME parts ---

multipart/alternative

text/plain (text body -- kept)

text/html

---

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/DFFF68D010E24AEB88D167C537C97224@OwnerPC

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

©2013 Gary Jeurink