创建数据库/表

/*
create database studentCourse
*/
use studentCourse
go
create table Student(
Sno char(6) Primary Key,
Sname nvarchar(20)not null,
Ssex nchar(1) not null default '男' check(Ssex in('男','女')),
Sbirthday smalldatetime,
Sdept nvarchar(20),
Memo text

)

use studentCourse
go
CREATE TABLE Course(
Cno CHAR(3) PRIMARY KEY,
Cname NVARCHAR(20) NOT NULL,
PerCno CHAR(3),
Credit TINYINT,
Semester TINYINT
)

use studentCourse
go
CREATE TABLE SC(
Sno CHAR(7),
Cno NCHAR(20) ,
Grade SMALLINT CHECK(Grade between 0 and 100),
PRIMARY KEY (Sno,Cno),
)

或

use testStudent
go
CREATE TABLE SC(
Sno CHAR(6),
Cno CHAR(3) ,
Grade SMALLINT CHECK(Grade between 0 and 100),
PRIMARY KEY (Sno,Cno),
FOREIGN KEY(Sno) REFERENCES Student(Sno),
FOREIGN KEY(Cno) REFERENCES Course(Cno),
)