(1)对数据表的基本操作

create table Course
(
   Cno char(4) primary key,
   Cname char(40),
   Cpno char(4),
   Ccredit smallint,
   foreign key (Cpno) references Course(Cno)
)

create table SC
(
  Sno char(9),
  Cno char(4),
  Grade smallint,
  primary key(Sno,Cno),
  foreign key(Sno) references Student(Sno),
  foreign key(Cno) references Course(Cno)
)

insert into Student values('3030','ff','男',20,'CS')


update Student set Sdept='Math' where Sno='3030'

alter table Student add S_entrance datetime

delete from Student where Sdept='Math'

备注：SQL第一次上机报告。