实验一-交互式SQL(内附答案).doc

create table STUDENT (SNO int primary key, SNAME char(8) unique, SSEX char(2), DEPTNO int ); create table COURSE (CNO int , CNAME char(20) unique, TNO int, CREDIT int, primary key(CNO,TNO) ); create table SC (SNO int, CNO int, GRADE int, primary key(SNO,CNO) ); create table TEACHER (TNO