-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hello all...
Well, I'm off to the races. I looked around the internet a little bit and
found that there are indeed Opensource/Free Gradebooks out there to be had.
The problems with them are that they are too big/comprehensive, too difficult
to use (we're talking teachers here!), don't have web-based interfaces, or
have to built from scratch by somebody. Teachers don't have time for this.
To start, I've put together some basic SQL tables, but before I commit them
to the database, I would like to solicit comment from my primary Linux
community about basic design, things I might have missed, etc. I'm using
Postgresql as my database, and the web-based interface will be built with
Zope.
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.
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_)
Thanks for your help!
Russell
- --
Linux -- the OS for the Renaissance Man
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org
iD8DBQE9q4aZAqKGrvVshJQRAmrCAJ9QrzDvY4BRn8mw/2wy1m45vMK6dACgvZOO
bnQlrEleXjdNPiSl75LMLBs=
=BlAE
-----END PGP SIGNATURE-----
This archive was generated by hypermail 2.1.3 : Fri Aug 01 2014 - 16:10:53 EDT