create table school(
id number primary key ,
schoolName varchar2(20) not null ,
address varchar2(50)
);
create table teacher(
id number primary key ,
teacherName varchar2(20) not null ,
sex varchar(2) ,
schoolId number ,
constraint fk_t_s_id foreign key(schoolId) references school(id)
);