1) 用SQL语言CREATE TABLE语句创建学生表student、课程表course和选课表SC;(字段类型及长度自己确定)
STUDENT(SNO,SNAME,SSEX,SAGE,SDEPT,ADDRESS);
Create table students(
Sno char(10),
Sname char(15),
Ssex char(2),
Sage int,
Sdept char(20),
Address char(50));
创建COURSE(CNO,CNAME,CPNO,CREDIT)
Create table courses(
Cno char(10),
Cname char(15),
Cpno char(15),
Credit char(20));
创建SC(SNO,CNO,GRADE)
Create table scs(
Sno char(10),
Cno char(15),
Grade decimal(5,1));