3. 创建表sc

CREATE TABLE student (
	sno CHAR (9) NOT NULL PRIMARY KEY COMMENT '学生ID',
	sname CHAR (4) NOT NULL COMMENT '姓名',
	ssex CHAR (2) COMMENT '性别',
	sage SMALLINT COMMENT '年龄',
	sdept CHAR (20) COMMENT '所在系'
);
CREATE TABLE course (
	cno CHAR (4) NOT NULL PRIMARY KEY COMMENT '课程ID',
	cname CHAR (40) NOT NULL COMMENT '课程名',
	cpno CHAR (4) COMMENT '先行课（参照自身，Cno）',
	ccredit SMALLINT COMMENT '学分'
);
CREATE TABLE sc (
	sno CHAR (9) NOT NULL COMMENT '学生ID（参照student，Cno）',
	cno CHAR (4) NOT NULL COMMENT '课程ID（参照course，Cno）',
	grade SMALLINT COMMENT '成绩'
);