I am going to design a Java application that connect to a database to store member registration to the organization I attend too. In My Design I would Like to store the attendance of each member of each day. Done once a day every day except Wednesday. Create Reports. and print labels to send letters by post.
I have made some fields that I need and divided them a bit.
Title -> Sir, Maddem , etc
House Number or House Name:
Class --> An other Table with the list of Classes
I need to link the Parent with Child: One Parent many Children
I need to link The Each Child with A History of Attendance:
Name Surname : 2007: January == attended 15 times
" : 2007: February = attended 10 times
Name Surname : 2008: January == attended 8 times
" : 2008: February = attended 4 times