2015数据库实验答案分析总结.docVIP

实验三 用SQL语句完成以下的要求（键表及插入数据的SQL语句见）：create table student( Sno char(5) primary key, Sname char(10), Ssex char(2), Sage int, Sdept char(2)); create table Course( Cno char(1) primary key, Cname char(20), Cpno char(1), Ccredit int); create table SC( Sno char(5), Cno char(1), Grade int, primary key (sno,cno)); insert into student values(95001,李勇,男,20,CS); insert into student values(95002,刘晨,女,21,IS); insert into student values(95003,王敏,女,18,MA); insert into student values(95004,张力,男,19,IS); insert into Course values(1,数据库,5,4); insert into Course values(2,数学,NULL,2); insert into Course