SQL 语句创建 Student、Course、SC 表（空表） - 数据库 Student_info

-- 创建Student表 CREATE TABLE Student ( Sno CHAR(8) NOT NULL PRIMARY KEY, Sname VARCHAR(8) NOT NULL, Sex CHAR(2) NOT NULL DEFAULT '男', Birth SMALLDATETIME NOT NULL, Classno CHAR(3) NOT NULL, Entrance_date SMALLDATETIME NOT NULL, Home_addr VARCHAR(40) );

-- 创建Course表 CREATE TABLE Course ( Cno CHAR(3) NOT NULL PRIMARY KEY, Cname VARCHAR(20) NOT NULL, Total_perior SMALLINT CHECK(Total_perior>0), Credit TINYINT CHECK(Credit>0 AND Credit<=6) );

-- 创建SC表 CREATE TABLE SC ( Sno CHAR(8) NOT NULL, Cno CHAR(3) NOT NULL, Grade TINYINT CHECK(Grade>=0 AND Grade<=100), PRIMARY KEY (Sno, Cno), FOREIGN KEY (Sno) REFERENCES Student(Sno), FOREIGN KEY (Cno) REFERENCES Course(Cno) );