Himadri
Himadri

Reputation: 3012

Help needed in database design for application of Timetable Generation

I am planning for an application of time-table generation. I wanted the data such as standardname, teachername, standard wise subjects and also relate the corresponding teacher with the subject and standard.

I had think like,

StandardMaster(stdid,stdname)  
TeacherMaster(teacherid,teachername)  
SubjectMaster(subid,subname,stdid)

I want the table with relation of teacher subject and standard tables.What more I need? Any corrections needed in these three tables?

Upvotes: 0

Views: 419

Answers (1)

Randy
Randy

Reputation: 16673

hm. looks like you also need relations between the teacher and the subject also - the Master can be left off safely in the names.

**standard**
standard_id
name

**teacher**
teacher_id
name

**subject**
subject_id
name

**subject_standard**
subject_id
standard_id
begin_date
end_date

**subject_teacher**
subject_id
teacher_id
begin_date
end_date

Upvotes: 1

Related Questions