471,049 Members | 1,438 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,049 software developers and data experts.

Database Structure

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
Jul 20 '05 #1
1 1845
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
---------------------------------------------------------------
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by bryja_klaudiusz[at]poczta[dot]fm | last post: by
1 post views Thread by Srihari | last post: by
346 posts views Thread by rkusenet | last post: by
25 posts views Thread by Colin McKinnon | last post: by
3 posts views Thread by josh.kuo | last post: by
8 posts views Thread by situ | last post: by
9 posts views Thread by Peter Duniho | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.