CREATE TABLE Student
(Sno CHAR (9) PRIMARY KEY,
Sname CHAR (a) UNIQUE,
Ssex CHAR (2),
Sage SMALLINT,
Sdept CHAR (20));
INSERT into student values (' 201215121 ', ' Li Yong ', ' Male ', ' CS ');
INSERT into student values (' 201215122 ', ' Liu Chen ', ' female ', ' CS ');
INSERT into student values (' 201215123 ', ' Wang Min ', ' female ', ' MA ');
INSERT into student values (' 201215125 ', ' Zhang Li ', ' Male ', ' is ');
INSERT into student values (' 201215126 ', ' Li Yiping ', ' Male ', ' is ');
INSERT into student values (' 201215127 ', ' Zhang Qin ', ' female ', ' CS ');
INSERT into student values (' 201215128 ', ' contacts ', ' female ', ' MA ');
INSERT into student values (' 201215129 ', ' Huang Linlin ', ' Male ', ' is ');
CREATE TABLE Course
(Cno CHAR (4) PRIMARY KEY,
Cname CHAR (40),
Cpno CHAR (4),
Ccredit SMALLINT,
);
Insert into course values (' 1 ', ' Database ', ' 5 ', 4);
Insert into course values (' 2 ', ' math ', null,2);
Insert into course values (' 3 ', ' Information system ', ' 1 ', 4);
Insert into course values (' 4 ', ' Operating system ', ' 6 ', 3);
Insert into course values (' 5 ', ' data structure ', ' 7 ', 4);
Insert into course values (' 6 ', ' Data processing ', null,2);
Insert into course values (' 7 ', ' C language ', ' 6 ', 4);
CREATE TABLE SC
(Sno CHAR (9),
Cno CHAR (4),
Grade SMALLINT,
PRIMARY KEY (SNO,CNO))
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 (' 201215121 ', ' 4 ', 98);
INSERT into SC values (' 201215121 ', ' 5 ', 89);
INSERT into SC values (' 201215121 ', ' 6 ', 95);
INSERT into SC values (' 201215121 ', ' 7 ', 93);
INSERT into SC values (' 201215122 ', ' 2 ', 90);
INSERT into SC values (' 201215122 ', ' 3 ', 80);
INSERT into SC values (' 201215122 ', ' 4 ', 85);
INSERT into SC values (' 201215122 ', ' 6 ', 92);
INSERT into SC values (' 201215123 ', ' 1 ', 90);
INSERT into SC values (' 201215123 ', ' 2 ', 84);
INSERT into SC values (' 201215123 ', ' 3 ', 91);
INSERT into SC values (' 201215123 ', ' 4 ', 90);
INSERT into SC values (' 201215123 ', ' 5 ', 80);
INSERT into SC values (' 201215123 ', ' 6 ', 78);
INSERT into SC values (' 201215123 ', ' 7 ', 65);
INSERT into SC values (' 201215128 ', ' 1 ', 78);
INSERT into SC values (' 201215128 ', ' 2 ', 82);
INSERT into SC values (' 201215128 ', ' 3 ', 77);
INSERT into SC values (' 201215128 ', ' 4 ', 79);
INSERT into SC values (' 201215128 ', ' 5 ', 92);
INSERT into SC values (' 201215128 ', ' 6 ', 98);
INSERT into SC values (' 201215128 ', ' 7 ', 50);
INSERT into SC values (' 201215125 ', ' 1 ', 67);
INSERT into SC values (' 201215125 ', ' 2 ', 71);
INSERT into SC values (' 201215125 ', ' 3 ', 90);
INSERT into SC values (' 201215126 ', ' 4 ', 81);
INSERT into SC values (' 201215126 ', ' 5 ', 90);
INSERT into SC values (' 201215126 ', ' 6 ', 56);
INSERT into SC values (' 201215126 ', ' 7 ', 89);
INSERT into SC values (' 201215127 ', ' 1 ', 81);
INSERT into SC values (' 201215127 ', ' 2 ', 72);
INSERT into SC values (' 201215127 ', ' 3 ', 90);
INSERT into SC values (' 201215127 ', ' 4 ', 64);
INSERT into SC values (' 201215127 ', ' 5 ', 79);
INSERT into SC values (' 201215127 ', ' 6 ', 50);
INSERT into SC values (' 201215127 ', ' 7 ', 96);
SQL creates a Student information table