.1学生表CREATE TABLEclass(classNochar(6) NOT NULL,classNamevarchar(20) NOT NULL,departmentvarchar(30) NOT NULL,gradeint(11) DEFAULT NULL,numberint(11) DEFAULT NULL,PRIMARY KEY (classNo) USING BTREE) ENGINEInnoDB DEFAULT CHARSETutf8 ROW_FORMATDYNAMIC;课程表CREATE TABLEcourse(courseNochar(6) NOT NULL,courseNamevarchar(20) NOT NULL,pointint(11) NOT NULL,hourint(11) NOT NULL,termchar(2) DEFAULT NULL,leadchar(6) DEFAULT NULL,PRIMARY KEY (courseNo) USING BTREE) ENGINEInnoDB DEFAULT CHARSETutf8 ROW_FORMATDYNAMIC;成绩表CREATE TABLEscore(studentNochar(8) NOT NULL,courseNochar(6) NOT NULL,scoreint(11) NOT NULL,PRIMARY KEY (studentNo,courseNo) USING BTREE) ENGINEInnoDB DEFAULT CHARSETutf8 ROW_FORMATDYNAMIC;学生表CREATE TABLEstudent(studentNochar(10) NOT NULL,studentNamevarchar(20) NOT NULL,genderchar(2) NOT NULL DEFAULT ‘男’,birthdaydate DEFAULT NULL,addressvarchar(20) DEFAULT ‘河北省石家庄市’,nationalvarchar(10) DEFAULT ‘汉’,phonechar(11) DEFAULT NULL,classNOchar(6) DEFAULT NULL,PRIMARY KEY (studentNo) USING BTREE,KEYclassNO(classNO) USING BTREE,CONSTRAINTstudent_ibfk_1FOREIGN KEY (classNO) REFERENCESclass(classNo)) ENGINEInnoDB DEFAULT CHARSETutf8 ROW_FORMATDYNAMIC;