I have 7 tables one is faculty_subjects rest are Monday,Tuesday,Wednesday,Thursday,Friday and Saturday my tables structure is like this
我有7个表一个是faculty_subjects休息的是周一,周二,周三,周四,周五和周六我的表结构是这样的
i have attached image url http://s27.postimg.org/434y3255f/School_Management_System.jpg i tried to make whole design here but everything mashedup
我有附加图像网址http://s27.postimg.org/434y3255f/School_Management_System.jpg我试图在这里做整个设计,但一切mashedup
live static page http://www.school.eptins.com/ when someone select class and section relevent to that subjects and faculty display in fields.
现场静态页面http://www.school.eptins.com/当有人选择课程和部分相关的主题和教师在字段中显示。
1 个解决方案
#1
0
I think time-table for one class is a table in itself. Instead of scattering time-table information of a classroom over 6 different tables, you could keep a table name timetable_IA and that table could have first column for periods (Period I, Period II, Period II, ...) and second column for subjects on Monday, third column for subjects on Tuesday, etc.
我认为一个类的时间表本身就是一个表。您可以保留一个表名timetable_IA,而不是将教室的时间表信息分散到6个不同的表中,并且该表可以包含第一列(句号I,句号II,句号II,...)和第二列的科目星期一,星期二的第三栏,等等。
That way, when a person chooses class IA, you have to just gather information from one table only.
这样,当一个人选择IA类时,您只需从一个表中收集信息。
For the second table (Subject Faculty), you could make an array of subjects appearing in time-table by reading time-table of IA, and then call in names of faculty teaching those subjects and construct the table.
对于第二个表(学科教师),您可以通过阅读IA的时间表,在时间表中出现一系列主题,然后调用教授这些主题并构建表格的教师姓名。
#1
0
I think time-table for one class is a table in itself. Instead of scattering time-table information of a classroom over 6 different tables, you could keep a table name timetable_IA and that table could have first column for periods (Period I, Period II, Period II, ...) and second column for subjects on Monday, third column for subjects on Tuesday, etc.
我认为一个类的时间表本身就是一个表。您可以保留一个表名timetable_IA,而不是将教室的时间表信息分散到6个不同的表中,并且该表可以包含第一列(句号I,句号II,句号II,...)和第二列的科目星期一,星期二的第三栏,等等。
That way, when a person chooses class IA, you have to just gather information from one table only.
这样,当一个人选择IA类时,您只需从一个表中收集信息。
For the second table (Subject Faculty), you could make an array of subjects appearing in time-table by reading time-table of IA, and then call in names of faculty teaching those subjects and construct the table.
对于第二个表(学科教师),您可以通过阅读IA的时间表,在时间表中出现一系列主题,然后调用教授这些主题并构建表格的教师姓名。