[Zope-DB] Database design help

[Russell Hires]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hello everyone, 

I want to create a gradebook for teachers based on zope, and after tossing 
this around my local LUG, I'd like the opinion of the experts on my schema 
(especially since I'm very non-expert) for the database part of the gradebook 
project. If this is off topic, please let me know, and I'll take this off the 
list...

TIA

Russell

Primary keys are in CAPS....
student(STUDENT_ID, Fname, Mname, Lname, address, city, state, zip, 
grade_level, mother_name, father_name, comments)

classes(CLASS_ID, name, description, grade_level, semester, school_year, 
class_period, room_number)

teacher(TEACHER_ID, Fname, Lname, Mname)

assignments(ASSIGN_ID, student_ID, date_assigned, assign_desc, grade_earned, 
comment)

grades(STUDENT_ID, CLASS_ID, semester, school_year, grade)

students_classes(STUDENT_ID, CLASS_ID)

teachers_classes(TEACHER_ID, CLASS_ID) 


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

iD8DBQE97Xy7AqKGrvVshJQRAj+WAJ0dT+eou8kH95XzrgUeiRJ9lTqbqQCg6uZw
p8taCGpTSbK4tedjoJ+JYoM=
=b566
-----END PGP SIGNATURE-----