I need help with an attendance system which has been bothering me for a while.
The Scenario: A company provides Seminars (expl a seminar on Gardening in April, a seminar on Programming in June, etc...). Each seminar is divided into sessions/days (session1, session2, session3, etc...). People sign up for a seminar of their choice. Say, 25 people signed up for Seminar7 that has 5 sessions. The 25 names are recorded in a Registration table which is a child table of Seminars. Thus, when viewing a parent record (Seminar) we can can see the list of people who signed up for each Seminar. So far so good.
My big issue is designing an attendance system to keep track of who showed up, who did not. The best I could do was this:
I created an Attendance table with the following fields: SeminarID, SessionID, Name, Attended (T or F).
For each session, I import the names from Registration table for the parent record and select T or F if the student attended or not. For expl: If 30 people signed up for Seminar28 (Registration tbl for this Seminar shows 30 child record) that has 5 sessions, the Attendance table receives 5 times the 30 same records=150 records to keep track of attendances; in other words, a name is duplicated as many times as there are sessions in a seminar. This is clearly not an efficient way. An Excel version would have the 30 names listed only once in rows and 5 columns (1 for each session) where the user just tick T or F.
Any suggestions, pointers will be highly appreciated. Thanks
The Scenario: A company provides Seminars (expl a seminar on Gardening in April, a seminar on Programming in June, etc...). Each seminar is divided into sessions/days (session1, session2, session3, etc...). People sign up for a seminar of their choice. Say, 25 people signed up for Seminar7 that has 5 sessions. The 25 names are recorded in a Registration table which is a child table of Seminars. Thus, when viewing a parent record (Seminar) we can can see the list of people who signed up for each Seminar. So far so good.
My big issue is designing an attendance system to keep track of who showed up, who did not. The best I could do was this:
I created an Attendance table with the following fields: SeminarID, SessionID, Name, Attended (T or F).
For each session, I import the names from Registration table for the parent record and select T or F if the student attended or not. For expl: If 30 people signed up for Seminar28 (Registration tbl for this Seminar shows 30 child record) that has 5 sessions, the Attendance table receives 5 times the 30 same records=150 records to keep track of attendances; in other words, a name is duplicated as many times as there are sessions in a seminar. This is clearly not an efficient way. An Excel version would have the 30 names listed only once in rows and 5 columns (1 for each session) where the user just tick T or F.
Any suggestions, pointers will be highly appreciated. Thanks
Comment