01-09-13, 10:00 #1Registered User
- Join Date
- Jan 2013
Online MySQL Student attendance system
I am making an attendance system with multiple classes of different group size and date.
I have designed this database but cannot find a way to record students presence without duplication.
id varchar (e.g. Teacher = 'T00231', Student = 'S10220')
teacherId varchar (use id from user)
groupId int (use id from studentGroup)
studentId varchar (use id from user)
classId int (use id from class)
Initially, the user, class and studentGroup tables will be populated.
When a teacher logs in, they will be prompted with a list of classes which are taught on that day.
When they click a class, a register appears listing the associated student group to be marked.
My problem lies with storing the 'presence' values. Any ideas?
Thanks in advance
01-09-13, 12:02 #2World Class Flame Warrior
- Join Date
- Jun 2003
"presence" should be the StudentID.
...and I hate your naming convention. Don't use "ID" in every table. Use [TableName]ID, consistently in both parent tables and foreign key references.
01-09-13, 12:31 #3Jaded Developer
- Join Date
- Nov 2004
- out on a limb
I guess it comes down to what you are trying to model and what you are trying to capture as attendance
for me you'd need to know the students, courses and or subjects, what courses a person is enrolled in, what the schedule for the courses/subjects is, and from that records a specific persons attendance on that subjects specific instance (ie class)
whether recording the day is good enough depends on what you are trying to achieve.
in my experience an attendance regsiter can be taken either at the day or half day level IE not against a specific subject, whereas some places want to know if some had attended a specific class. some other places record percentage of attendance (IE person X attended DB concepts calls on Wednesday 8th Jan for 50% of the time)
CS caters for a course that can comprises a range of subjects
S caters for a series of subjects that a student is studying
Again in my experience most places requiring an attendance record have a detailed requirement (eg wehere a student or pupil may study from a range of subjects (CS)I'd rather be riding on the Tiger 800 or the Norton