数据库练习题（一）

2019.1.8

首先建立三个表 STUDENT，SC，COURSE

CREATE TABLE "SC" (
"SNO" VARCHAR2(20), 
"CNO" VARCHAR2(20), 
"GRADE" VARCHAR2(20)
);

 CREATE TABLE "STUDENT" (
"SNO" VARCHAR2(20), 
"SNAME" VARCHAR2(20), 
"SEX" VARCHAR2(20),
 "DNO" VARCHAR2(20)
);
CREATE TABLE "COURSE" (
"CNO" VARCHAR2(20), 
"CNAME" VARCHAR2(20),
"TNAME" VARCHAR2(20)
);

接着分别向三个表中插入数据

Insert into SC (SNO,CNO,GRADE) values ('0001','327401','70');
Insert into SC (SNO,CNO,GRADE) values ('1001','327401','80');
Insert into SC (SNO,CNO,GRADE) values ('1002','327401','90');
Insert into SC (SNO,CNO,GRADE) values ('1003','327401','85');
Insert into SC (SNO,CNO,GRADE) values ('1004','327401','87');
Insert into SC (SNO,CNO,GRADE) values ('1005','327401','86');
Insert into SC (SNO,CNO,GRADE) values ('1006','327401','56');
Insert into SC (SNO,CNO,GRADE) values ('1001','153701','85');
Insert into SC (SNO,CNO,GRADE) values ('1002','153701','60');
Insert into SC (SNO,CNO,GRADE) values ('1003','153701','70');
Insert into SC (SNO,CN