[SLUG] RFC: Gradebook Project Database

From: Russell Hires (rhires@earthlink.net)
Date: Mon Oct 14 2002 - 23:08:08 EDT


-----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