[计算机设计论文精品] 学生信息管理系统 报告

件:CREATETABLESCORE(ScoreIDintNOTNULL,StudentNointNOTNULL,CourseIDintNOTNULL,ScorefloatNOTNULL,PRIMARYKEY(ScoreID),FOREIGNKEY(CourseID)REFERENCESCourse(CourseID)ONDELETENOACTIONONUPDATECASCADE);REATETABLECOURSE(CourseIDintNOTNULL,ClassNamevarchar(20)NOTNULL,SubjectNamevarchar(20)NOTNULL,Teachervarchar(20)NOTNULL,BeginDatedatetimeNOTNULL,FinishDatedatetimeNOTNULL,Remarkvarchar(256),PRIMARYKEY(CourseID),FOREIGNKEY(ClassName)REFERENCESClass(ClassName)ONDELETENOACTIONONUPDATECASCADE,FOREIGNKEY(Teacher)REFERENCESTeacher(TeacherName)ONDELETENOACTIONONUPDATECASCADE,FOREIGNKEY(SubjectName)REFERENCESSubject(SubjectName)ONDELETENOACTIONONUPDATECASCADE);创建数据库对象CLASS表的SQL脚本文件:CREATETABLECLASS(ClassNamevarchar(20)NOTNULL,Directorvarchar(20)NOTNULL,CurrentCountsmallintNOTNULL,EntranceDatedatetimeNOTNULL,