CREATE TABLE Student (
Sno CHAR(7) PRIMARY KEY,
Sname NVARCHAR(5) NOT NULL,
Ssex NCHAR(1),
Sage TINYINT,
Sdept NVARCHAR(20)
)
CREATE TABLE Course (
Cno CHAR(6),
Cname NVARCHAR(20) NOT NULL,
Credit TINYINT,
Semester TINYINT,
PRIMARY KEY(Cno)
)
CREATE TABLE SC (
Sno CHAR(7) NOT NULL,
Cno CHAR(6) NOT NULL,
Grade TINYINT,
PRIMARY KEY (Sno, Cno),
FOREIGN KEY (Sno) REFERENCES Student (Sno),
FOREIGN KEY (Cno) REFERENCES Course (Cno)
)
insert into student values('0811101','李勇','男',21,'计算机系')
insert into student values('0811102','刘晨','男',20,'计算机系')
insert into student values('0811103','王敏','女',20,'计算机系')
insert into student values('0811104','张小红','女',19,'计算机系')
insert into student values('0821101','张立','男',20,'信息管理系')
insert into student values('0821102','吴宾','女',19,'信息管理系')
insert into student values('0821103','张海','男',20,'信息管理系')
insert into student values('0831101','钱小平','女',21,'通信工程系')
insert into student values('0831102','王大力','男',20,'通信工程系')
insert into student values('0831103','张姗姗','女',19,'通信工程系')
insert into course values('C001','高等数学',4,1)
insert into course values('C002','大学英语',3,1)
insert into course values('C003','大学英语',3,2)
insert into course values('C004','计算机文化学',2,2)
insert into course values('C005','VB',2,3)
insert into course values('C006','数据库基础',4,5)
insert into course values('C007','数据结构',4,4)
insert into course values('C008','计算机网络',4,4)
insert into sc values('0811101','C001',96)
insert into sc values('0811101','C002',80)
insert into sc values('0811101','C003',84)
insert into sc values('0811101','C005',62)
insert into sc values('0811102','C001',92)
insert into sc values('0811102','C002',90)
insert into sc values('0811102','C004',84)
insert into sc values('0821102','C001',76)
insert into sc values('0821102','C004',85)
insert into sc values('0821102','C005',73)
insert into sc values('0821102','C007',NULL)
insert into sc values('0821103','C001',50)
insert into sc values('0821103','C004',80)
insert into sc values('0831101','C001',50)
insert into sc values('0831101','C004',80)
insert into sc values('0831102','C007',NULL)
insert into sc values('0831103','C004',78)
insert into sc values('0831103','C005',65)
insert into sc values('0831103','C007',NULL)
