insert into LOCATION (LOCATION_ID,DESCRIPTION) values (1,'Downtown Main Branch');
insert into LOCATION (LOCATION_ID,DESCRIPTION) values (2,'Valley Branch');
insert into LOCATION (LOCATION_ID,DESCRIPTION) values (3,'Douglas Branch');
insert into BOOK (CATALOG_NO,TITLE,KEYWORDS,DATE_ADDED,COST,LOCATION_ID) values ('156592262X','Java in a Nutshell','java, programming','2000-11-30',50,1);
insert into BOOK (CATALOG_NO,TITLE,KEYWORDS,DATE_ADDED,COST,LOCATION_ID) values ('1565924940','Dynamic HTML','javascript, programming, html','2000-10-05',39.95,3);
insert into BOOK (CATALOG_NO,TITLE,KEYWORDS,DATE_ADDED,COST,LOCATION_ID) values ('0078820979','Oracle The Complete Reference 3rd Edition','oracle, programing, database','2000-11-05',88.99,2);
insert into BOOK (CATALOG_NO,TITLE,KEYWORDS,DATE_ADDED,COST,LOCATION_ID) values ('1565921275','Essential System Administration 2nd Edition','unix, administration','2000-12-31',45.96,1);
insert into BOOK (CATALOG_NO,TITLE,KEYWORDS,DATE_ADDED,COST,LOCATION_ID) values ('0789719932','Using StarOffice for the Beginner','office, applications','2000-12-05',39.95,2);
insert into BOOK (CATALOG_NO,TITLE,KEYWORDS,DATE_ADDED,COST,LOCATION_ID) values ('0201702673','Applying Enterprise JavaBeans','java, j2ee, programming','2001-07-05',39.95,3);
insert into BOOK (CATALOG_NO,TITLE,KEYWORDS,DATE_ADDED,COST,LOCATION_ID) values ('0201705028','JNDI API Tutorial and Reference','jndi, java','2001-07-03',42.95,1);
insert into BOOK (CATALOG_NO,TITLE,KEYWORDS,DATE_ADDED,COST,LOCATION_ID) values ('013127604','Essential CSS and DHTML for Web Professionals','html, css, dhtml','2001-07-05',29.99,2);
insert into BOOK (CATALOG_NO,TITLE,KEYWORDS,DATE_ADDED,COST,LOCATION_ID) values ('0471332291','Mastering Enterprise JavaBeans and the Java 2 Plat','java, j2ee, ejb','2001-07-05',49.99,3);
insert into BOOK (CATALOG_NO,TITLE,KEYWORDS,DATE_ADDED,COST,LOCATION_ID) values ('0782121802','Mastering Java 2','java, programming','2001-07-14',49.95,3);
insert into BOOK (CATALOG_NO,TITLE,KEYWORDS,DATE_ADDED,COST,LOCATION_ID) values ('1565927443','SQL in a Nutshell','sql, database','2001-07-22',29.95,2);
insert into BOOK (CATALOG_NO,TITLE,KEYWORDS,DATE_ADDED,COST,LOCATION_ID) values ('1565924495','Using Samba','samba, network, server','2002-11-06',34.95,2);
commit;