Catalog
Chapter one Introduction to system requirements 4
1.1 Demand analysis 4
1.2 Data structure requirements analysis 4
1.3 System function design 5
Chapter two Requirements describe 8
2.1 Data flow diagram 8
2.2 The data dictionary 9
The third chapter conceptual design 10
3.1 Entity 10
3.2 The whole system E-R chart 11
3.3 Conceptual data model design 12
Chapter four logic design 13
4.1 ER Transformation from graph to relational schema 13
4.2 Table structure design of each data table 13
The fifth chapter physical design 15
5.1 Database software 15
5.2 Create data table 15
Chapter six Processing data 18
6.1 Data requirement 18
6.2 Reading data 18
6.3 Processing data 19
6.4 Make Sql sentence 22
Chapter vii. Intelligent course scheduling algorithm 28
7.1 Course scheduling requirements 28
7.2 preparation 28
7.3 Genetic algorithm (ga) 30
7.4 Fitness function 32
7.5 Course scheduling effect 33
Chapter viii. system implementation 35
8.1 Login interface 35
8.2 Student interface 35
8.2.1 Student personal information interface 35
8.2.2 Student personal schedule interface 36
8.2.3 Student course selection interface 36
8.2.4 Student withdrawal interface 37
8.2.5 Student view result interface 37
8.3 Teacher interface 37
8.3.1 Teacher information interface 37
8.3.2 Teaching courses and course adjustment system interface 37
8.3.3 Course student list interface 38
8.3.4 Register points 、 Scheduling subsystem interface 38
8.4 Dean interface 39
8.4.1 View all student interfaces 39
8.4.2 Class results 、 Ranking of professional scores 39
8.4.3 View all teachers 40
8.4.4 Check out all courses 40
8.4.5 View all class schedules 42
Chapter nine appendix 45
9.1 Genetic algorithm code 45
9.2 Database connection 、 Add, delete and change code 53
9.3 Front end design code 55
9.4 Execute code 55
Chapter 1 Introduction to system requirements
1.1 Demand analysis
Implement a specific course management system . According to the idea of software engineering, a simplified professional course database is designed , Try to simulate the actual situation of the prototype of course selection and scheduling of the existing professional courses for one semester .（ notes ： This system is designed by myself 、 Development complete ）
1.2 Data structure requirements analysis
The main functions of the course management system include ：
(1) Inquiry of students' basic information , Students can modify their system login password .
(2) Students customize their own timetables , You can view my course schedule for the whole semester , Including course name 、 Class time 、 Place of class 、 Teacher 、 Credits, etc .
(3) Students can choose courses , The professional compulsory course system will help students choose in advance .
(4) Students can withdraw from classes , Professional compulsory courses are not allowed to be withdrawn .
(5) Students can check the grades of their selected courses , And the scores of each course 、 Grade point , And give its GPa , But it is not allowed to view the grades of other students in the grade .
(6) Inquiry of basic information of teachers , Teachers can modify their system login password .
(7) Teachers can view the course information they teach , Including course name 、 Class time 、 Place of class 、 Class, class, etc .
(8) Teachers can adjust their courses , Course adjustment can be successfully adjusted without any conflict in the whole course time .
(9) Teachers can view the list of students in each course they teach .
(10) Teachers can register and modify the scores of students in their courses .
(11) Teachers can sort the grades of their classes .
(12) The dean of the Department has the authority including all the above teachers , And the following additional permissions .
(13) The Dean can view all the students in the whole department and their GPA , You can rank each class , Or you can rank the whole department .
(14) The Dean can check the list of teachers in the whole department , And the number of courses they are responsible for .
(15) The Dean can view all the courses offered throughout the semester , Include full details of these courses .
(16) The Dean can view the course schedule of each class .
1.3 System function design
The course management system is mainly divided into three client logins , Students 、 Teachers and department heads , The functions of each client are different . The login of these three clients has its own function implementation . The following three figures are the function module diagrams of the three clients .
Reprinted from ：http://www.biyezuopin.vip/onews.asp?id=16294
