Seeking database design, classes, student questions, online, etc.

kuikui

If there is a school with several classes, the number of students in each class is different from the student name
How to do database table design
How about the following design?
1, classTable table
   ID studentID ClassName
    Class 1, 1, 3, 5
    Class 2, 2, 4, 6, 7
.........


2, studentTable table
   ID studentName
   Few photos
   2 Guo Jing
   3 Wei packet
   4 Aaron Kwok
.........

Is there a better design? Solve online!

sinexe

studentTable
   ID studentName class
   1 sheet only
   2 Guo Jing High School Class 1
   3 Wei Xiaobao High School Class 1
   4 Guo Fucheng High School Class 1

fanfan1980

Class table
Student table
Class relationship table

kuikui

The method ofsinexesinexeseems to be very good, how can I not think of it, huh, huh

kuikui

fanfan1980
Ask, what is the specific implementation of your method?

fanfan1980

Class table
classID ClassName

Student table
studentID studentName

Class relationship table
classID studentID Flag (whether the flag is valid, so you can check the history)

kuikui

Thank you ~~