Database Structure

[Maarten Hendrikx]

Hi,

We're planning a web application which
will allow teachers to plan their teacher diary online.
So for instance:
Mondag 8.50 - 9.40 --> Math (First Grade)
Mondag 9.40 - 10.30 --> French (Sixth Grade)
And so on for an entire week.
We have made some simple applications using only
a limited number of tables. But we're having some
trouble with the database structure for this one.
More specific: we're guessing we can't use one table
for the entire week schedule of all the teachers. But
do we have to make a new table for every teacher or
a new table for each day?
We would appreciate it if somebody could advise us
on our database structure.

Thanks,
MJ

[Jeff North]

On 24 Aug 2004 05:50:05 -0700, in mailing.database.mysql
mj********@yahoo.com (Maarten Hendrikx) wrote:

| Hi,
|
| We're planning a web application which
| will allow teachers to plan their teacher diary online.
| So for instance:
| Mondag 8.50 - 9.40 --> Math (First Grade)
| Mondag 9.40 - 10.30 --> French (Sixth Grade)
| And so on for an entire week.
| We have made some simple applications using only
| a limited number of tables. But we're having some
| trouble with the database structure for this one.
| More specific: we're guessing we can't use one table
| for the entire week schedule of all the teachers. But
| do we have to make a new table for every teacher or
| a new table for each day?
| We would appreciate it if somebody could advise us
| on our database structure.

Teachers
---------
TeacherID int(11) not null auto-increment
TeacherName varchar(100) default ''
username varchar(25)
password varchar(25)

Classes
-------
ClassID int(11) not null auto-increment
ClassName varchar(50)

Grade
-----
GradeID int(11) not null auto-increment
GradeName varchar(50)

Diary
-----
DiaryID int(11) not null auto-increment
TeacherID int(11) not null default 0
ActivityDate date
ActivityTime time
ActivityDuration int(11)
ClassID int(11) not null default 0
GradeID int(11) not null default 0
---------------------------------------------------------------
jn****@yourpantsbigpond.net.au : Remove your pants to reply
---------------------------------------------------------------