Table 1. Students are required to have but not only has the following properties: student id, name, age, gender, phone number, class, the teacher in charge number, the teacher in charge's name; Teacher table shall be but not only has the following properties: teacher's number, teacher's name, age, gender, phone number, taught classes (each teachers teach more than one class, a comma in English).
Table 2. The students student id primary key, each year, more than ten most classes, each class up to 10 people, the number of small class number is automatically assigned to the next class, the 11 students are automatically assigned to 2 classes, student id class rules for the A + B + serial number, such as class 1, class of 2020 people, 10 student number is 20200110, every new cadets, increasing student number automatically, the no. 11 students of 20200201
10 (3), and received a total of 99 students, teachers, a teacher at the head teacher of class a, due to different subjects, and each teacher needs to teach several classes, including sports, music, politics, biology, chemistry, physics teacher, ten classes are taught, two Chinese and two math teacher teaches five classes each, teacher's name is zhao sports, music, politics, sun mr.li, weeks chemical, physical, wu zheng Chinese, Chinese, wang Chen feng mathematics, mathematics
Write relevant program
Have a great god with me,, feel good complex
CodePudding user response:
After you break down complex problem becomes a question of a simple,CodePudding user response:
Step by step, there will be no less complicated