数据库代码-实验六.docVIP

实验三代码 create table Course( Cid char(6) primary key, Cname char(20) unique, Ccredit int ); create table Teacher( Tid char(6) primary key, Tname char(20), Tdept char(20), TstartDate char(20) ); create table Class( Classid char(6) primary key, ClassDept char(10) ); create table Classroom( Roomid char(6) primary key, Building char default TB1, RoomType char(20) ); create table Student( Sid char(6), Sname char(20) Constraint SnameUnique Unique(Sname), Sage smallint Constraint SageConstraint check(Sage=10 and Sage=30), Ssex char(2) Check(S