Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2013
    Posts
    1

    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.

    user
    ======================
    id varchar (e.g. Teacher = 'T00231', Student = 'S10220')
    password varchar


    class
    ======================
    id int
    name varchar
    teacherId varchar (use id from user)
    groupId int (use id from studentGroup)
    weekDay varchar


    studentGroup
    ======================
    id int
    studentId varchar (use id from user)


    classAttendance
    ======================
    classId int (use id from class)
    presence int


    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

    Nathan

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    "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.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    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)
    Attached Files Attached Files
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •