(1) Establishing a conceptual model of student score management system (students can choose multiple courses, manage students per class)
(2) Data definition
(3) Establish a database (table, index, relationship, constraint)
(4) Enter data
(5) Data query
1. Find the basic situation of all students, curriculum settings and course conditions (unconditional query)
2. Find out any of the students, courses and grades (conditional query)
3. Find a lesson of the child and put the results from the big to small arrangement (sort query)
4. Find the course number to XXX and students in less than 80 points (nested query)
5. Number of electives in each class (calculation query)
(6) Data added, delete
1. Add a record to the base table and add the student's class information (data insert) in the selection form.
2. Search the average score of each student and save the results in the table (STU_AVGRADE) (nesting data insert)
3. Remove the students from XXXXXX from the table Student (single record delete)
4. Delete all the qualifications through the exam (multi-record delete)
(7) Data update
1. Raise all achievements in 55 points above 5 points
(8) Establishing a charter view for each class, using a cursor to calculate the average score of each lesson
(9) Establish a stored procedure for printing the results of each class student and statistics
