数据库原理及安全（一）

建表+插入数据操作

CREATE TABLE Student
(
Sno CHAR(9) PRIMARY KEY,
Sname CHAR(20) UNIQUE,
Ssex CHAR(2),
Sage SMALLINT,
Sdept CHAR(20)
);

CREATE TABLE Course
(
Cno CHAR(4) PRIMARY KEY,
Cname CHAR(40) NOT NULL,
Cpno CHAR(4),
Ccredit SMALLINT,
FOREIGN KEY (Cpno) REFERENCES Course(Cno)
);


CREATE TABLE SC
(
Sno CHAR(9),
Cno CHAR(4),
Grade SMALLINT,
PRIMARY KEY(Sno,Cno),
FOREIGN KEY (Sno) REFERENCES Student(Sno),
FOREIGN KEY (Cno) REFERENCES Course(Cno)
);

INSERT 
INTO Student
VALUES('201215121','李勇','男',20,'CS');
INSERT 
INTO Student
VALUES('201215122','刘晨','女',19,'CS');
INSERT 
INTO Student
VALUES('201215123','王敏','女',18,'MA');
INSERT 
INTO Student
VALUES('201215124','张立','男',19,'IS');

INSERT
INTO Course
VALUES('2','数学',NULL,2);
INSERT
INTO Course
VALUES('6','数据处理',NULL,2);

INSERT
INTO Course
VALUES('4','操作系统','6',3);
INSERT
INTO Course
VALUES('7','PASCAL语言','6',4);

INSERT
INTO Course
VALUES('5','数据结构','7',4);

INSERT
INTO Course
VALUES('1','数据库','5',4);

INSERT
INTO Course
VALUES('3','信息系统','1',4);

INSERT 
INTO SC
VALUES('201215121','1',92);
INSERT 
INTO SC
VALUES('201215121','2',85);
INSERT 
INTO SC
VALUES('201215121','3',88);
INSERT 
INTO SC
VALUES('201215122','2',90);
INSERT 
INTO SC
VALUES('201215122','3',80);


INSERT 
INTO SC
VALUES('201215121','1',92);
INSERT 
INTO SC
VALUES('201215121','2',85);
INSERT 
INTO SC
VALUES('201215121','3',88);
INSERT 
INTO SC
VALUES('201215122','2',90);
INSERT 
INTO SC
VALUES('201215122','3',80);