1,创建一个教学管理系统的学生表和课程选修表
USE YYJ
GO
CREATE TABLE S
(SNO CHAR(9) NOT NULL
CONSTRAINT PK_SNO PRIMARY KEY CLUSTERED
CHECK(SNO LIKE'200915121[0-9][0-9]'),
SNAME CHAR(8) NOT NULL,
SEX CHAR(2) NULL,
AGE SMALLINT NULL,
SDEPT VARCHAR(50) NULL
)
GO
USE YYJ
GO
CREATE TABLE C
(CNO CHAR(4) NOT NULL,
CNAME VARCHAR(50) NOT NULL,
CDEPT VARCHAR(50) NULL,
TNAME CHAR(8),
PRIMARY KEY(CNO)
)
GO
USE YYJ
GO
CREATE TABLE SC
(SNO CHAR(9) NOT NULL,
CNO CHAR(4) NOT NULL,
GRADE REAL NULL,
PRIMARY KEY(SNO,CNO),
FOREIGN KEY(SNO) REFERENCES S(SNO),
FOREIGN KEY(CNO) REFERENCES C(CNO)
)
GO