学生选课管理系统数据库设计

student_course存储过程调用语句 declare v_no sc.sno%type; begin v_no:=&input; student_course(v_no); end; ----------------------------------------------------------------------------------- student_grade_course存储过程调用语句 declare v_no sc.sno%type; begin v_no:=&input; student_grade_course(v_no); end; ----------------------------------------------------------------------------------- student_select_course存储过程调用语句 declare v_sno sc.sno%type; v_cno sc.cno%type; v_tno sc.tno%type; begin v_sno:=&inputsno; v_cno:=&inputcno; v_tno:=&inputtno; student_select_course(v_sno,v_cno,v_tno); end; ----------------------------------------------------------------------------------- course_grade存储过程调用语句 declare a sc.cno%type; b number; c number; d number; begin a:=&inputcno; course_grade(a,b,c,d); dbms_output.put_line('平均成绩：'||b||' 最高成绩：'||c||' 最低成绩：'||d); end; ----------------------------------------------------------------------------------- 课程及格人数存储过程调用语句 declare a sc.cno%type; b number; begin a:=&inputcno; 课程及格人数(a,b); dbms_output.put_line(b); end; ----------------------------------------------------------------------------------- 课程选课人数存储过程调用语句 declare a sc.cno%type; b number; begin a:=&inputcno; 课程选课人数(a,b); dbms_output.put_line(b); end; ----------------------------------------------------------------------------------- course_student存储过程调用语句 declare v_no sc.cno%type; begin v_no:=&input; course_student(v_no); end; ----------------------------------------------------------------------------------- course_teacher_student存储过程调用语句 declare v_cno sc.cno%type; v_tno sc.tno%type; begin v_cno:=&inputcno; v_tno:=&inputtno; course_teacher_student(v_cno,v_tno); end; ----------------------------------------------------------------------------------- insert_apply存储过程调用语句 declare v_ano apply.ano%type; v_action apply.action%type; v_cno apply.cno%type; v_cname apply.cname%type; v_credit apply.credit%type; v_PROPERTY apply.PROPERTY%type; v_term apply.term%type; v_college apply.college%type; begin v_ano:=&inputano; v_action:=&inputaction; v_cno:=&inputcno; v_cname:=&inputcname; v_credit:=&inputcredit; v_PROPERTY:=&inputPROPERTY; v_term:=&inputterm; v_college:=&inputcollege; insert_apply(v_ano,v_action,v_cno,v_cname,v_credit,v_PROPERTY,v_term,v_college); end; ----------------------------------------------------------------------------------- all_grade存储过程调用语句 begin all_grade; end;