Table name

The meaning of the field name data type indicates the constraint condition.

Jsbh Char(6) Teacher Number Main Keyword

Rkjsxm Char( 12) Teacher's name is not empty.

Jszc Char( 10) teacher title can be empty.

…….…… ……

Functional requirements of reference student status management information system

1. Summarize the total number of students of all majors and grades and the number of boys and girls by department, and count the total number of students in the whole school.

Requirements: Enter any department name, major name and grade, and the corresponding information will be returned.

2. Summarize the number of students of all ages and the number of boys and girls by department.

Requirements: Enter any department name and age, and the corresponding information can be returned.

The number of students in each region depends on the system.

Requirements: Enter any department name or region name to return the corresponding number of students.

4. According to any semester (user input), statistics of students' change data (such as resumption, suspension, withdrawal, expulsion, transfer-in, transfer-out, graduation, withdrawal, etc.). ).

5. Statistics on the number of party member and League members among students by department.

Requirements: When the name of a department is entered at will, the number of students in party member and the number of members in the department can be returned.

6, according to the number of students of all ethnic groups.

Requirements: When you enter any department name and nationality, you can return the corresponding information.

7, statistics of the distribution of the scores of each course:

These include:

1) (90- 100, 80-90, 70-80, 60-70, 0-59) and their respective percentages in the actual number of applicants.

2) Count the number of people who are absent from the exam.

3) Count the number of people who passed and failed.

8, statistics of each student's comprehensive evaluation score:

1) Total score = average score *0.7+ German score *0.3.

2) Comprehensive evaluation ranking.

3) Evaluate the scholarship level according to the total score (principal, first, second and third).

4) According to the academic year, according to the students' learning situation (failing three (above) make-up exams or graduating from one (above) make-up exams), the candidates for promotion and re-reading are determined.

9. Inquire about students' grades (by student number, name, class, course and semester respectively), and the displayed information can be customized.

10. When the information changes, the corresponding records of related tables should also change. (such as repeating a grade, making-up exams, etc. )

The application of 1 1. subquery;

Find the student record with the highest total score of accrual class 04 1 than accrual class 042.

12, create the following view:

1) V_ students' grades: including students' names, course names and grades.

2) V_ class number: including class name, department, specialty name and class number.