学生-课程数据库sql.txt

DROP TABLE SC
DROP TABLE Student
DROP TABLE Course


CREATE TABLE Student
(
Sno CHAR(5) PRIMARY KEY,
Sname CHAR(20) UNIQUE,
Ssex CHAR(2),
Sage INTEGER,
Sdept CHAR(15)
);


INSERT INTO Student(Sno,Sname,Ssex,Sage,Sdept) VALUES('95001','李勇','男',20,'CS');
INSERT INTO Student(Sno,Sname,Ssex,Sage,Sdept) VALUES('95002','刘晨','女',19,'IS');
INSERT INTO Student(Sno,Sname,Ssex,Sage,Sdept) VALUES('95003','王敏','女',18,'MA');
INSERT INTO Student(Sno,Sname,Ssex,Sage,Sdept) VALUES('95004','张立','男',19,'IS');
INSERT INTO Student(Sno,Sname,Ssex,Sage,Sdept) VALUES('95005','郑民','男',20,'CS');
INSERT INTO Student(Sno,Sname,Ssex,Sage,Sdept) VALUES('95006','刘米','女',19,'IS');
INSERT INTO Student(Sno,Sname,Ssex,Sage,Sdept) VALUES('95007','王兰','女',18,'MA');
INSERT INTO Student(Sno,Sname,Ssex,Sage,Sdept) VALUES('95008','张标','男',19,'IS');

GO
CREATE TABLE course
(
Cno CHAR(8) PRIMARY KEY,
  Cname CHAR(20),
Cpno CHAR(8),