Have bosses have a look at my schedule in this university library table relationship is reasonable,

My main idea is divided into professional courses and individual courses, specialized courses in class, so built the class table, professional curriculum, the curriculum schedule, teachers' table,
Individual courses built elective course list, elective course schedule, according to the situation of students' course selection specific query

Here the teacher table is a common table, of course, elective curriculum can be designed into a table, but separate will be good to elective module operating point, the library table relationships, the most important is to maintain two relational tables, difficulty of maintenance is not easy to

Rightness, forgot to say to realize the function, the function is actually a dynamic schedule, depending on the student login name query each student's curriculum, the idea was thought is so complex that really do think it is quite complicated, because the relationship between them is a one-to-many or many-to-many, associate will not be easy, but also to consider the late can dynamically delete make up a missed lesson, a robust library table design is quite important,

This design is reasonable?
thank you for your guidance

Graph one is to realize the train of thought, figure 2 is a professional class er diagram, figure 3 is to simulate the query professional schedule, book is a professional course schedule (relational tables)

CodePudding user response:

Student the teacher course three basic tables
The teacher lesson course teachers -
Student - course course selection table

These five tables can complete the main function, are set by details,

Class has nothing to do with the course of the university, is a display of data, can consider to build a class table alone, correspondence course selection should be professional,
- curriculum table still need to build a, used to check whether students complete the course selection,