create table salesorder(orderno varchar(10) primary key,orderdate varchar(10)not null,s_no varchar(5),deltype char check(deltype in('p','f')),orderstatus varchar(15) check (orderstatus in('inprocess','backorder','cancelled','fullfilled')),foreign key(s_no)references sales_man(s_no));