> But here's the tables. The way I've got this is in a shorthand format, with
> underscores around the primary key of each table. The table names will have
> _tbl at the end of their names, and will be the item directly before the
> opening parenthesis.
>
You really don't need to add the "_tbl" to each name. SQL isn't prone
to the kind of confusion that would require _tbl.
> Student_Tbl(_STUDENT_ID_, FNAME,
> LNAME,SSN,ADDRESS,CITY,ST,ZIP,GRADELEVEL,MOTHERNAME,FATHERNAME)
>
> CLASSES_TBL(_CLASS_ID_,NAME,DESCRIPTION)
>
> STUDENTS_CLASSES_TBL(_STUDENT_ID_, _CLASS_ID_, CLASS_PERIOD,GRADE_AVG)
>
> TEACHER_TBL(_TEACHER_ID_,FNAME,LNAME,SSN,ADDRESS,CITY,STATE,ZIP)
>
> TEACHER_CLASS_TBL(_TEACHER_ID, _CLASS_ID_, _CLASS_PERIOD_)
>
This is for teachers to use as a gradebook. You need at least one more
layer, probably two. Underneath the TEACHER_CLASS_TBL, the teachers
need to be able to represent the grading structure of the class (e.g.
homework=20% of the grade, midterm=30% of the grade, final=50%):
GRADE_CATEGORY (_GCID_, TEACHER_ID, CLASS_ID, CATEGORY, WEIGHT)
Then, you need to have a table for the individual grades (each test,
quiz, homework item, extra credit, etc.). This way, a teacher can
demonstrate WHY little johnny got an F on his overall homework grade,
and thus got a D in the class. Teachers are called on the carpet over
this kind of stuff all the time! You should really do two tables for
this, one defines each item (such as "3/23/1989: Recitation of the
prologue to the Canterbury Tales" or "2/14/1989: Dissection of fetal
pig".) It might be nice to allow the teachers to assign weights to each
assignment, but that could just be confusing (and the teachers can
work-around such a lack by being more detailed in the CATEGORY
assignments (e.g. if a teacher wants to give more weight the pig
dissection than to litmus testing, then instead of making a category
called "Lab", they can make two categories called "Lab: basic" and "Lab:
dissection" and assign appropriate weights)).
WORK_ITEM (_WIID_, GCID, WWHEN, TITLE, DESCRIPTION);
PERFORMANCE (_PERFID_, WIID, STUDENT_ID, GRADE, INCOMPLETE, COMMENT);
Early in the school year (more likely before the school year begins),
the teacher would set-up the entire semester or year for each class.
The gradebook could also create a browseable and printable syllabus that
the students and parents can look-at. The weights of the assignments
should probably also be on the syllabus (with disclaimer, "All dates and
assignments are subject to change.")
--ronan
This archive was generated by hypermail 2.1.3 : Fri Aug 01 2014 - 16:11:05 EDT