Now what do you want to be a teaching management system, including the preservation of all information curriculum (attributes: course number, course name, school, etc.), would like to ask: how should save time this information? Note: class time can be any day between Monday to Friday, and may be a day of lecture 11 in any of the sections,

Thank you very grateful ~ ha ha ~ first

CodePudding user response:

Do a table, (number, class time), using the time type, then the associated with the curriculum

CodePudding user response:

Make a schedule, (number, class time) and class time with tinyint (or int) type, then the associated with the curriculum
Class time, 1 said Monday, section 1, 2, section 2 said Monday,,,,,,, 11, said on Monday the 11th day
Section 1 13 said Tuesday,,,,,,, 23, said Tuesday the 11th day
25 said Wednesday, section 1,,,,, 35, said Wednesday the 11th day
,,,
Section 1, 49 said Friday,,,, 59 said Friday 11th day
Access to judge if the int (class time, 12) + 1 week, mod (class time, 12) which section

A course number corresponding to multiple records in on schedule

CodePudding user response:

Class time with a string type
1-1
1 day on Monday5-11 section 11 on Friday

CodePudding user response:

The whole system design, according to a single object for correlation

CodePudding user response:

# 2 is a great idea
Is built three tables:
Curriculum (attributes: course number, course name, school, etc.)
Schedule (time number. Specific time)
Course _ time corresponding to the table (number) course number, time

CodePudding user response:

Can build the table, also can build a single column, in the line of needs to save again