Then write your SQL
create table title (title_id char(6) not null constraint tididx primary key constraint tidcheck check (title_id like ‘[A-Z] [A-Z] [0-9] [0-9]…’), title varchar(80) not null constraint titleidx unique, type char(12) default ‘unclassified’ null constraint typechk check (type in(‘business’, ‘mod_cook’, ‘trad_cook’)), pub_id char(4) null reference publishers (pub_id), price money null, advance money null)