【Oracle】创建以下两个表，主键，联合主键，默认值，检查

create table t_student(
  no varchar2(11) primary key,
  name varchar2(10),
  sex char(10) default '男'
); 

 

create table t_score(
  no varchar2(11),
  cno varchar2(10),
  score number(3,1) check (score >= 0),
  constraint pk_cno_no primary key(no,cno),
  constraint fk_no foreign key(no) references t_student(no)
);