Reputation: 3012
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
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