Advice on multiple table set up

I was asked about setting up a database for an online student grade/attendence system. I know that several tables will be needed, one for student info, one for attendence, and one or more for classes/grades. There are 4 classes, and need to display teacher name, grading period grades, total grade, and teacher comments. Besides the student info and attendence tables, should each class have its own table, meaning I'll need a total of 6? Can that many tables be joined? I havent decided to do this since I have several questions about this setup. Any suggestions are appreciated.

OK, this is how I would probably end up organizing the tables (you may not need all of them):

table "PEOPLE" to hold personal information and ids of students, faculty, TAs, graders, tutors, or anyone else associated with the institution.

table "COURSES" to hold course id, description, credits, title, etc but NOT lecture id, grader id, etc (this should not be fixed - there may be more than one lecturer or tutor etc per course)

tables "LECTURERS", "TUTORS", "GRADERS", "TAS" (teaching assistants) and "CLASSES" will hold the lecture/tutor/grader/TA/student id and an associated course id.

table "ASSINGMENTS" to hold assignment data - type(test, exam, hw, etc), name, description, due date, start date for each course.

table "WEEKLYSCHEDULES" to hold start and end times for weekly meetings in each course

table "EXAMSCHEDULES" to hold start & end times for exam(s) in each course

table "ATTENDANCE" to hold a student id, date, and schedule id.

table "GRADINGCRITERIA" to hold a weight factor (test, exam, hw, etc) and respective total weight for the factor in each course

table "GRADES" to hold a grade (%), student id and assignment id.

tables "PREREQUISITES" and "COREQUISITES" to hold a course id and pre/co-requisite id.

You may also consider a table that will store summaries of grades from previous semesters - otherwise it's a lot of processing to generate the overall GPA etc.

Thnx for the response. I'm not sure I would need quite that much info stored. I went ahead and made a setup that works, but I'm pretty sure it's on the inefficient side. I've tried setting up table joins, etc., to no avail, so I basically ran it all in two table (one for vary basic student info and attendance, one for classes & grades). Probably very incorrect, but as I said, it does work. The person needing this program basically has no budget for this, so if I do it, I really only want the experience/knowledge of setting up something more advanced than I already have. If anyone would be interested in helping/guiding this setup, I'd appreciate any help offered. A sample of what it will basically be can be seen here...
<a href=mdhwebdesign.com/grades/public/index.html>Sample Page</a>
Use student number 111111 & password 888888
Thnks again