《数据库原理与应用》实验指导书修改版(1)(16)

CNO CHAR(8) NOT NULL, GRADE FLOAT,

CHECK (GRADE BETWEEN 0 AND 100),

PRIMARY KEY (SNO,CNO),

FOREIGN KEY(SNO)REFERENCES student, FOREIGN KEY(CNO)REFERENCES course) GO

单击快捷工具栏的执行图标“

”执行上述语句，四张表便创建完成。