insert into subject(categoryid,subjectdesc,keywords) values (1,'American','yankee,deep south, wild west, dollar'); 
insert into subject(categoryid,subjectdesc) values (1,'English'); 
insert into subject(categoryid,subjectdesc) values (1,'French'); 
insert into subject(categoryid,subjectdesc) values (2,'Original Creation'); 
insert into subject(categoryid,subjectdesc) values (2,'Reinterpretation'); 
insert into subject(categoryid,subjectdesc) values (2,'Retelling'); 
insert into subject(categoryid,subjectdesc,keywords) values (3,'Adventure','action,mystery,fun,suspense, thriller'); 
insert into subject(categoryid,subjectdesc,keywords) values (3,'Children and Young Adult','baby,child,toddler,growing mind'); 
insert into subject(categoryid,subjectdesc,keywords) values (3,'Crime and Mystery','mystery,crime,blood, gun, violence'); 
insert into subject(categoryid,subjectdesc,keywords) values (3,'Historical','regency, history,british history, world history, middle ages'); 
insert into subject(categoryid,subjectdesc,keywords) values (3,'Horror','mystery,ghost,scary,demon,devil,death'); 
insert into subject(categoryid,subjectdesc,keywords) values (3,'Religious','god,christian,muslim,hindu,truth'); 
insert into subject(categoryid,subjectdesc) values (3,'Western'); 
insert into subject(categoryid,subjectdesc,keywords) values (4,'Autobiography and Biography','life story,account,true story'); 
insert into subject(categoryid,subjectdesc,keywords) values (4,'Science','technology,advances,biology,physics, genetics, chemistry, math,mathematics');