DROP TABLE AUTHORS cascade constraints; DROP TABLE BOOK_ITEMS cascade constraints; DROP TABLE BOOKS cascade constraints; DROP TABLE BORROWING cascade constraints; DROP TABLE CUSTOMERS cascade constraints; DROP TABLE WRITING cascade constraints; CREATE TABLE AUTHORS ( AUTHOR_ID NUMBER(10,0), LAST_NAME VARCHAR2(30 CHAR), FIRST_NAME VARCHAR2(20 CHAR), BIRTH_DATE DATE ) ; CREATE TABLE BOOK_ITEMS ( BOOK_ITEM_ID VARCHAR2(20 CHAR), BOOK_ID NUMBER(10,0), THEORETICAL_VALUE NUMBER(10,2) ) ; CREATE TABLE BOOKS ( BOOK_ID NUMBER(10,0), TITLE VARCHAR2(200 CHAR), ISBN VARCHAR2(13 CHAR), PUBLISHER VARCHAR2(200 CHAR), PUBLISHING_DATE DATE, PRICE NUMBER(8,0), TOPIC VARCHAR2(30 CHAR), NUMBER_OF_PAGES NUMBER(4,0) ) ; CREATE TABLE BORROWING ( CUSTOMER_ID VARCHAR2(20 CHAR), BOOK_ITEM_ID VARCHAR2(20 CHAR), BORROWING_DATE DATE, BORROWING_PERIOD_IN_DAYS NUMBER(3,0) DEFAULT 30, BRING_BACK_DATE DATE, LATE_FEE NUMBER(6,0) ) ; CREATE TABLE CUSTOMERS ( LIBRARY_CARD_NUMBER VARCHAR2(20 CHAR), LAST_NAME VARCHAR2(30 CHAR), FIRST_NAME VARCHAR2(20 CHAR), BIRTH_DATE DATE, GENDER CHAR(1 CHAR), ADDRESS VARCHAR2(200 CHAR), ENROLLMENT_DATE DATE, MEMBERSHIP_FEE NUMBER(5,0), CATEGORY VARCHAR2(20 CHAR) ) ; CREATE TABLE WRITING ( AUTHOR_ID NUMBER(10,0), BOOK_ID NUMBER(10,0), ROYALTY NUMBER ) ; Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182601','Christie','Agatha',to_date('1890-09-15','YYYY-Mm-DD')); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182602','Banner','A. J.',to_date('1966-05-21','YYYY-Mm-DD')); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182603','Matthews','John',to_date('1956-03-20','YYYY-Mm-DD')); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182604','Cooper','Glenn',null); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182605','King','Stephen',to_date('1947-09-21','YYYY-Mm-DD')); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182606','Harrison','Harry',to_date('1925-03-12','YYYY-Mm-DD')); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182607','Smith','Mike',null); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182608','Asimov','Isaac',to_date('1920-01-02','YYYY-Mm-DD')); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182609','Manheim','Ralph',null); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182611','Hitler','Adolf',to_date('1944-11-08','YYYY-Mm-DD')); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182613','Zimmerman','Dwight Jon',null); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182614','O''Reilly','Bill',null); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182615','Dugard','Martin',null); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182616','Castelot','Andr�',to_date('1911-01-23','YYYY-Mm-DD')); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182617','Lefebvre','Georges',to_date('1874-08-06','YYYY-Mm-DD')); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182618','Allaby','Michael',to_date('1933-09-01','YYYY-Mm-DD')); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182619','Dr. Coenraads','Robert R.',null); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182620','Hutchinson','Robert',to_date('1957-11-12','YYYY-Mm-DD')); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182621','Mcghee','Karen',null); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182622','Dr. O''Byrne','John',null); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182623','Dr. Rubin','Ken',null); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182624','Attenborough','David',to_date('1926-05-08','YYYY-Mm-DD')); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182625','Sparks','John',to_date('1943-09-01','YYYY-Mm-DD')); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182626','Beatty','Richard',null); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182627','Bryan','Kim',null); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182628','Burnie','David',null); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182629','Dinwiddie','Robert',to_date('1963-07-27','YYYY-Mm-DD')); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182630','Dipper','Frances',null); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182631','Eales','Philip',to_date('1970-09-01','YYYY-Mm-DD')); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182632','Halls','Monty',null); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182633','Scott','Sue',null); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182634','Scott','Mike',null); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182635','Cousteau','Fabien',to_date('1890-09-15','YYYY-Mm-DD')); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182636','Rees','Martin',null); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182637','Hughes','David',null); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182638','Nicolson','Iain',null); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182639','Ridpath','Ian',null); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182640','Sparrow','Giles',null); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182641','Spence','Pam',null); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182642','Stott','Carole',null); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182643','Tildsley','Kevin',null); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182644','J�kai','M�r',to_date('1825-02-18','YYYY-Mm-DD')); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182645','M�ra','Ferenc',to_date('1879-07-19','YYYY-Mm-DD')); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182646','Br�dy','S�ndor',null); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182647','R�kosi','Viktor',null); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182648','Mackey','Alex',null); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182649','Bloch','Joshua',null); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182650','Gafter','Neal',null); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182651','Bradley','Neil',null); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182652','Graham','Steve',null); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182653','Simeonov','Simeon',null); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182654','Fowler','Martin',to_date('1963-09-01','YYYY-Mm-DD')); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182655','Gamma','Erich',to_date('1961-09-01','YYYY-Mm-DD')); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182656','Helm','Richard',null); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182657','Johnson','Ralph',null); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182658','Vlissides','John M.',null); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182659','Winfrey','Oprah',null); Insert into AUTHORS (AUTHOR_ID,LAST_NAME,FIRST_NAME,BIRTH_DATE) values ('2005182660','Druon','Maurice',to_date('1918-04-23','YYYY-Mm-DD')); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152201-1','1116152201','2084,7'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152201-2','1116152201','2079,4'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152201-3','1116152201','2074,1'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152201-4','1116152201','2068,8'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152201-5','1116152201','2063,5'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152202-1','1116152202','1400,7'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152202-2','1116152202','1395,4'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152202-3','1116152202','1390,1'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152202-4','1116152202','1384,8'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152202-5','1116152202','1379,5'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152202-6','1116152202','1374,2'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152206-1','1116152206','2089,7'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152206-2','1116152206','2084,4'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152206-3','1116152206','2079,1'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152207-1','1116152207','1662,7'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152207-2','1116152207','1657,4'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152207-3','1116152207','1652,1'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152207-4','1116152207','1646,8'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152208-1','1116152208','3310,7'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152208-2','1116152208','3305,4'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152208-3','1116152208','3300,1'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152208-4','1116152208','3294,8'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152208-5','1116152208','3289,5'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152208-6','1116152208','3284,2'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152209-1','1116152209','2994,7'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152209-2','1116152209','2989,4'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152210-1','1116152210','3034,7'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152211-1','1116152211','1864,7'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152211-2','1116152211','1859,4'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152211-3','1116152211','1854,1'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152212-1','1116152212','1677,7'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152212-2','1116152212','1672,4'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152212-3','1116152212','1667,1'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152212-4','1116152212','1661,8'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152212-5','1116152212','1656,5'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152212-6','1116152212','1651,2'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152212-7','1116152212','1645,9'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152217-2','1116152217','1025,4'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152217-3','1116152217','1020,1'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152218-1','1116152218','1194,7'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152218-2','1116152218','1189,4'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152219-1','1116152219','1494,7'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152219-2','1116152219','1489,4'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152219-3','1116152219','1484,1'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152219-4','1116152219','1478,8'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152220-1','1116152220','2654,7'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152221-1','1116152221','4735,7'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152222-1','1116152222','4735,7'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152223-1','1116152223','2294,7'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152223-2','1116152223','2289,4'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152223-3','1116152223','2284,1'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152223-4','1116152223','2278,8'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152224-1','1116152224','1494,7'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152224-2','1116152224','1489,4'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152224-3','1116152224','1484,1'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152224-4','1116152224','1478,8'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152225-1','1116152225','9485,7'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152225-2','1116152225','9480,4'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152225-3','1116152225','9475,1'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152225-4','1116152225','9469,8'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152225-5','1116152225','9464,5'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152225-6','1116152225','9459,2'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152225-7','1116152225','9453,9'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152225-8','1116152225','9448,6'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152225-9','1116152225','9443,3'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152225-10','1116152225','9491'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152225-11','1116152225','9485,7'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152226-1','1116152226','1894,7'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152226-2','1116152226','1889,4'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152226-3','1116152226','1884,1'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152226-4','1116152226','1878,8'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152226-5','1116152226','1873,5'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152227-1','1116152227','1695,7'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152227-2','1116152227','1690,4'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152227-3','1116152227','1685,1'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152228-1','1116152228','2075,7'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152228-2','1116152228','2070,4'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152228-3','1116152228','2065,1'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152228-4','1116152228','2059,8'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152229-1','1116152229','1194,7'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152229-2','1116152229','1189,4'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152229-3','1116152229','1184,1'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152230-1','1116152230','11036,7'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152231-1','1116152231','11036,7'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152232-1','1116152232','1505,7'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152232-2','1116152232','1500,4'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152233-1','1116152233','1609,7'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152233-2','1116152233','1604,4'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152233-3','1116152233','1599,1'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152233-4','1116152233','1593,8'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152233-5','1116152233','1588,5'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152233-6','1116152233','1583,2'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152234-3','1116152234','792,1'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152234-4','1116152234','786,8'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152235-1','1116152235','6635,7'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152235-2','1116152235','6630,4'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152236-1','1116152236','752,7'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152236-2','1116152236','747,4'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152236-3','1116152236','742,1'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152236-4','1116152236','736,8'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152236-5','1116152236','731,5'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152236-6','1116152236','726,2'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152236-7','1116152236','720,9'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152236-8','1116152236','715,6'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152237-1','1116152237','8544,7'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152238-1','1116152238','5214,7'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152238-2','1116152238','5209,4'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152238-3','1116152238','5204,1'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152239-1','1116152239','10254,7'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152239-2','1116152239','10249,4'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152239-3','1116152239','10244,1'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152240-2','1116152240','4730,4'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152241-1','1116152241','5519,7'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152241-2','1116152241','5514,4'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152243-1','1116152243','5974,7'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152243-2','1116152243','5969,4'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152244-1','1116152244','5974,7'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152244-2','1116152244','5969,4'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152244-3','1116152244','5964,1'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152245-1','1116152245','254,7'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152245-2','1116152245','249,4'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152245-3','1116152245','244,1'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152247-1','1116152247','994,7'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152248-1','1116152248','994,7'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152248-2','1116152248','989,4'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152251-1','1116152251','994,7'); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152216-1','1116152216',null); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152216-2','1116152216',null); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152217-1','1116152217',null); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152214-1','1116152214',null); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152215-1','1116152215',null); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152234-1','1116152234',null); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152234-2','1116152234',null); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152240-1','1116152240',null); Insert into BOOK_ITEMS (BOOK_ITEM_ID,BOOK_ID,THEORETICAL_VALUE) values ('FSZEK/1116152242-1','1116152242',null); Insert into BOOKS (BOOK_ID,TITLE,ISBN,PUBLISHER,PUBLISHING_DATE,PRICE,TOPIC,NUMBER_OF_PAGES) values ('1116152201','And Then There Were None','9789630788984','Fontana Books',to_date('1972-01-01','YYYY-Mm-DD'),'2090','Thriller','266'); Insert into BOOKS (BOOK_ID,TITLE,ISBN,PUBLISHER,PUBLISHING_DATE,PRICE,TOPIC,NUMBER_OF_PAGES) values ('1116152202','The Unexpected Guest','9789635490479','Minotaur Books',to_date('1999-10-16','YYYY-Mm-DD'),'1406','Thriller','200'); Insert into BOOKS (BOOK_ID,TITLE,ISBN,PUBLISHER,PUBLISHING_DATE,PRICE,TOPIC,NUMBER_OF_PAGES) values ('1116152203','Death Comes as the End','9789630786430','William Morrow Paperbacks',to_date('2012-03-13','YYYY-Mm-DD'),'1900','Thriller','292'); Insert into BOOKS (BOOK_ID,TITLE,ISBN,PUBLISHER,PUBLISHING_DATE,PRICE,TOPIC,NUMBER_OF_PAGES) values ('1116152204','Crescents of the Moon','9789639300347','Arrow Books Ltd',to_date('1984-02-23','YYYY-Mm-DD'),'1836','Thriller','488'); Insert into BOOKS (BOOK_ID,TITLE,ISBN,PUBLISHER,PUBLISHING_DATE,PRICE,TOPIC,NUMBER_OF_PAGES) values ('1116152205','The Good Neighbor','9789632544137','Lake Union Publishing',to_date('2015-09-01','YYYY-Mm-DD'),'2799','Thriller',null); Insert into BOOKS (BOOK_ID,TITLE,ISBN,PUBLISHER,PUBLISHING_DATE,PRICE,TOPIC,NUMBER_OF_PAGES) values ('1116152206','The Crescent Wars','9789639300279','Amazon Digital Services LLC',to_date('2016-06-08','YYYY-Mm-DD'),'2095','Thriller','472'); Insert into BOOKS (BOOK_ID,TITLE,ISBN,PUBLISHER,PUBLISHING_DATE,PRICE,TOPIC,NUMBER_OF_PAGES) values ('1116152207','The Last Witness','9639300200','E-Media books',to_date('2013-11-25','YYYY-Mm-DD'),'1668','Thriller','490'); Insert into BOOKS (BOOK_ID,TITLE,ISBN,PUBLISHER,PUBLISHING_DATE,PRICE,TOPIC,NUMBER_OF_PAGES) values ('1116152208','Library of the Dead','9789639973114','Arrow',to_date('1994-06-01','YYYY-Mm-DD'),'3316','Thriller','400'); Insert into BOOKS (BOOK_ID,TITLE,ISBN,PUBLISHER,PUBLISHING_DATE,PRICE,TOPIC,NUMBER_OF_PAGES) values ('1116152209','Witness for the Prosecution','963841345X','William Morrow Paperbacks',to_date('2012-08-07','YYYY-Mm-DD'),'3000','Thriller','254'); Insert into BOOKS (BOOK_ID,TITLE,ISBN,PUBLISHER,PUBLISHING_DATE,PRICE,TOPIC,NUMBER_OF_PAGES) values ('1116152210','Firestarter','9789630786836','Pocket Books ',to_date('2016-05-03','YYYY-Mm-DD'),'3040','Thriller','520'); Insert into BOOKS (BOOK_ID,TITLE,ISBN,PUBLISHER,PUBLISHING_DATE,PRICE,TOPIC,NUMBER_OF_PAGES) values ('1116152211','Dreamcatcher','9630779501','Pocket Books ',to_date('2001-12-01','YYYY-Mm-DD'),'1870','Science Fiction','752'); Insert into BOOKS (BOOK_ID,TITLE,ISBN,PUBLISHER,PUBLISHING_DATE,PRICE,TOPIC,NUMBER_OF_PAGES) values ('1116152212','Needful Things','9630778246','Pocket Books',to_date('2016-05-03','YYYY-Mm-DD'),'1683','Thriller','720'); Insert into BOOKS (BOOK_ID,TITLE,ISBN,PUBLISHER,PUBLISHING_DATE,PRICE,TOPIC,NUMBER_OF_PAGES) values ('1116152213','Dolores Claiborne','9600781875','Signet',to_date('1993-12-01','YYYY-Mm-DD'),'2125','Thriller','264'); Insert into BOOKS (BOOK_ID,TITLE,ISBN,PUBLISHER,PUBLISHING_DATE,PRICE,TOPIC,NUMBER_OF_PAGES) values ('1116152214','Deathworld ','9789639828605','CreateSpace Independent Publishing Platform',to_date('2014-09-08','YYYY-Mm-DD'),'3791','Science Fiction','460'); Insert into BOOKS (BOOK_ID,TITLE,ISBN,PUBLISHER,PUBLISHING_DATE,PRICE,TOPIC,NUMBER_OF_PAGES) values ('1116152215','The Last Praetorian','9789639566873','Amazon Digital Services LLC',to_date('2012-11-01','YYYY-Mm-DD'),'1753','Science Fiction','344'); Insert into BOOKS (BOOK_ID,TITLE,ISBN,PUBLISHER,PUBLISHING_DATE,PRICE,TOPIC,NUMBER_OF_PAGES) values ('1116152216','The Sunfire','9639346888','Amazon Digital Services LLC',to_date('2013-05-10','YYYY-Mm-DD'),'1444','Science Fiction','392'); Insert into BOOKS (BOOK_ID,TITLE,ISBN,PUBLISHER,PUBLISHING_DATE,PRICE,TOPIC,NUMBER_OF_PAGES) values ('1116152217','Lucky Starr and the Oceans of Venus','9637429174','Fawcett',to_date('1982-01-12','YYYY-Mm-DD'),'1036','Science Fiction','158'); Insert into BOOKS (BOOK_ID,TITLE,ISBN,PUBLISHER,PUBLISHING_DATE,PRICE,TOPIC,NUMBER_OF_PAGES) values ('1116152218','A Short History of Biology','11111111111','Doubleday',to_date('1964-09-01','YYYY-Mm-DD'),'1200','Science','278'); Insert into BOOKS (BOOK_ID,TITLE,ISBN,PUBLISHER,PUBLISHING_DATE,PRICE,TOPIC,NUMBER_OF_PAGES) values ('1116152219','The Tragedy of the Moon','22222222222','Dell Pub Co',to_date('1978-03-01','YYYY-Mm-DD'),'1500','Literature','310'); Insert into BOOKS (BOOK_ID,TITLE,ISBN,PUBLISHER,PUBLISHING_DATE,PRICE,TOPIC,NUMBER_OF_PAGES) values ('1116152220','Mein Kampf','9789632511993','Houghton Mifflin Company',to_date('1998-09-15','YYYY-Mm-DD'),'2660','History','128'); Insert into BOOKS (BOOK_ID,TITLE,ISBN,PUBLISHER,PUBLISHING_DATE,PRICE,TOPIC,NUMBER_OF_PAGES) values ('1116152221','Lincoln''s Last Days','9789633275092','Square Fish',to_date('2014-06-03','YYYY-Mm-DD'),'4741','History','112'); Insert into BOOKS (BOOK_ID,TITLE,ISBN,PUBLISHER,PUBLISHING_DATE,PRICE,TOPIC,NUMBER_OF_PAGES) values ('1116152222','Killing Kennedy: The End of Camelot','9789633274989','Henry Holt and Co.',to_date('2002-10-02','YYYY-Mm-DD'),'4741','History','150'); Insert into BOOKS (BOOK_ID,TITLE,ISBN,PUBLISHER,PUBLISHING_DATE,PRICE,TOPIC,NUMBER_OF_PAGES) values ('1116152223','Napoleon','9500274612','Ishi Press',to_date('2009-11-23','YYYY-Mm-DD'),'2300','History','653'); Insert into BOOKS (BOOK_ID,TITLE,ISBN,PUBLISHER,PUBLISHING_DATE,PRICE,TOPIC,NUMBER_OF_PAGES) values ('1116152224','Napoleon','963280256X','The Folio Society',to_date('2009-01-01','YYYY-Mm-DD'),'1500','History','783'); Insert into BOOKS (BOOK_ID,TITLE,ISBN,PUBLISHER,PUBLISHING_DATE,PRICE,TOPIC,NUMBER_OF_PAGES) values ('1116152225','The Encyclopedia of Earth','9789630961615','Europe Publisher',to_date('2010-09-01','YYYY-Mm-DD'),'9491','Science','608'); Insert into BOOKS (BOOK_ID,TITLE,ISBN,PUBLISHER,PUBLISHING_DATE,PRICE,TOPIC,NUMBER_OF_PAGES) values ('1116152226','Towards Zero','9789630786249','William Morrow Paperbacks',to_date('2011-02-01','YYYY-Mm-DD'),'1900','Thriller','272'); Insert into BOOKS (BOOK_ID,TITLE,ISBN,PUBLISHER,PUBLISHING_DATE,PRICE,TOPIC,NUMBER_OF_PAGES) values ('1116152227','The Trials of Life: A Natural History of Animal Behavior','9638227117','Little, Brown',to_date('1990-04-01','YYYY-Mm-DD'),'1701','Science','326'); Insert into BOOKS (BOOK_ID,TITLE,ISBN,PUBLISHER,PUBLISHING_DATE,PRICE,TOPIC,NUMBER_OF_PAGES) values ('1116152228','The Living Planet: A Portrait of the Earth','9635300077','Little, Brown',to_date('1984-11-01','YYYY-Mm-DD'),'2081','Science','324'); Insert into BOOKS (BOOK_ID,TITLE,ISBN,PUBLISHER,PUBLISHING_DATE,PRICE,TOPIC,NUMBER_OF_PAGES) values ('1116152229','The First Eden: The Mediterranean World and Man ','9630267217','Little, Brown',to_date('1987-06-01','YYYY-Mm-DD'),'1200','Science','238'); Insert into BOOKS (BOOK_ID,TITLE,ISBN,PUBLISHER,PUBLISHING_DATE,PRICE,TOPIC,NUMBER_OF_PAGES) values ('1116152230','Ocean','9789639693456','M�rt�k Kiad�',to_date('2007-09-01','YYYY-Mm-DD'),'11042','Science','512'); Insert into BOOKS (BOOK_ID,TITLE,ISBN,PUBLISHER,PUBLISHING_DATE,PRICE,TOPIC,NUMBER_OF_PAGES) values ('1116152231','Universe','963-967-800-7','Europe Publisher',to_date('2007-09-01','YYYY-Mm-DD'),'11042','Science','512'); Insert into BOOKS (BOOK_ID,TITLE,ISBN,PUBLISHER,PUBLISHING_DATE,PRICE,TOPIC,NUMBER_OF_PAGES) values ('1116152232','Fairy Tales about King Matthias','9789639581197','Europe Publisher',to_date('2010-09-01','YYYY-Mm-DD'),'1511','Fairy Tales','48'); Insert into BOOKS (BOOK_ID,TITLE,ISBN,PUBLISHER,PUBLISHING_DATE,PRICE,TOPIC,NUMBER_OF_PAGES) values ('1116152233','Sons of the Slave Man','9789633468814','Europe Publisher',to_date('2010-09-01','YYYY-Mm-DD'),'1615','Fairy Tales','14'); Insert into BOOKS (BOOK_ID,TITLE,ISBN,PUBLISHER,PUBLISHING_DATE,PRICE,TOPIC,NUMBER_OF_PAGES) values ('1116152234','Golden Coffin','9789630779180','Europe Publisher',to_date('2005-09-01','YYYY-Mm-DD'),'808','Literature','472'); Insert into BOOKS (BOOK_ID,TITLE,ISBN,PUBLISHER,PUBLISHING_DATE,PRICE,TOPIC,NUMBER_OF_PAGES) values ('1116152235','1848 - The Hungarian Revolution','9789630960519','Europe Publisher',to_date('2009-09-01','YYYY-Mm-DD'),'6641','History','476'); Insert into BOOKS (BOOK_ID,TITLE,ISBN,PUBLISHER,PUBLISHING_DATE,PRICE,TOPIC,NUMBER_OF_PAGES) values ('1116152236','The Heartless Man''s Sons','9789636451004','Europe Publisher',to_date('2006-09-01','YYYY-Mm-DD'),'758','Literature','442'); Insert into BOOKS (BOOK_ID,TITLE,ISBN,PUBLISHER,PUBLISHING_DATE,PRICE,TOPIC,NUMBER_OF_PAGES) values ('1116152237','Introducing .NET 4.0: With Visual Studio 2010','9789639863170','Apress',to_date('2010-09-01','YYYY-Mm-DD'),'8550','Computer Science','572'); Insert into BOOKS (BOOK_ID,TITLE,ISBN,PUBLISHER,PUBLISHING_DATE,PRICE,TOPIC,NUMBER_OF_PAGES) values ('1116152238','Java Puzzlers - Traps, Pitfalls, and Corner Cases','9789639637702','Addison-Wesley',to_date('2005-07-04','YYYY-Mm-DD'),'5220','Computer Science','270'); Insert into BOOKS (BOOK_ID,TITLE,ISBN,PUBLISHER,PUBLISHING_DATE,PRICE,TOPIC,NUMBER_OF_PAGES) values ('1116152239','The XML-companion','9789639131712','Addison-Wesley',to_date('1998-09-01','YYYY-Mm-DD'),'10260','Computer Science','758'); Insert into BOOKS (BOOK_ID,TITLE,ISBN,PUBLISHER,PUBLISHING_DATE,PRICE,TOPIC,NUMBER_OF_PAGES) values ('1116152240','Building Web Services with Java','9789639301047','SAMS Publishing',to_date('2001-09-01','YYYY-Mm-DD'),'4741','Computer Science','644'); Insert into BOOKS (BOOK_ID,TITLE,ISBN,PUBLISHER,PUBLISHING_DATE,PRICE,TOPIC,NUMBER_OF_PAGES) values ('1116152241','Refactoring','9639637130','Addison-Wesley',to_date('1999-07-08','YYYY-Mm-DD'),'5525','Computer Science','372'); Insert into BOOKS (BOOK_ID,TITLE,ISBN,PUBLISHER,PUBLISHING_DATE,PRICE,TOPIC,NUMBER_OF_PAGES) values ('1116152242','Domain-Specific Languages','9780321712943','Addison-Wesley Professional',to_date('2010-10-03','YYYY-Mm-DD'),'8735','Computer Science','640'); Insert into BOOKS (BOOK_ID,TITLE,ISBN,PUBLISHER,PUBLISHING_DATE,PRICE,TOPIC,NUMBER_OF_PAGES) values ('1116152243','Design Patterns: Elements of Reusable Object-Oriented Software','9780201633610','Addison-Wesley Professional',to_date('1994-11-10','YYYY-Mm-DD'),'5980','Computer Science','416'); Insert into BOOKS (BOOK_ID,TITLE,ISBN,PUBLISHER,PUBLISHING_DATE,PRICE,TOPIC,NUMBER_OF_PAGES) values ('1116152244','Programtervez�si mint�k (Design Patterns)','9639301779','Kiskapu - Addison-Wesley',to_date('2004-09-01','YYYY-Mm-DD'),'5980','Computer Science','421'); Insert into BOOKS (BOOK_ID,TITLE,ISBN,PUBLISHER,PUBLISHING_DATE,PRICE,TOPIC,NUMBER_OF_PAGES) values ('1116152245','Nostradamus','9637905146','Media Publisher',to_date('1991-09-01','YYYY-Mm-DD'),'260',null,'362'); Insert into BOOKS (BOOK_ID,TITLE,ISBN,PUBLISHER,PUBLISHING_DATE,PRICE,TOPIC,NUMBER_OF_PAGES) values ('1116152246','The Bible Code','9639069817','Touchstone',to_date('1998-04-07','YYYY-Mm-DD'),'1495',null,'239'); Insert into BOOKS (BOOK_ID,TITLE,ISBN,PUBLISHER,PUBLISHING_DATE,PRICE,TOPIC,NUMBER_OF_PAGES) values ('1116152247','The Iron King','33333333333',null,null,null,null,null); Insert into BOOKS (BOOK_ID,TITLE,ISBN,PUBLISHER,PUBLISHING_DATE,PRICE,TOPIC,NUMBER_OF_PAGES) values ('1116152248','The Strangled Queen','44444444444',null,null,null,null,null); Insert into BOOKS (BOOK_ID,TITLE,ISBN,PUBLISHER,PUBLISHING_DATE,PRICE,TOPIC,NUMBER_OF_PAGES) values ('1116152249','The Lily and the Lion','55555555555',null,null,null,null,null); Insert into BOOKS (BOOK_ID,TITLE,ISBN,PUBLISHER,PUBLISHING_DATE,PRICE,TOPIC,NUMBER_OF_PAGES) values ('1116152250','Winnie-the-Pooh','66666666666',null,null,null,null,null); Insert into BOOKS (BOOK_ID,TITLE,ISBN,PUBLISHER,PUBLISHING_DATE,PRICE,TOPIC,NUMBER_OF_PAGES) values ('1116152251','The King Without a Kingdom','77777777777',null,null,null,null,null); Insert into BORROWING (CUSTOMER_ID,BOOK_ITEM_ID,BORROWING_DATE,BORROWING_PERIOD_IN_DAYS,BRING_BACK_DATE,LATE_FEE) values ('E-2010/151020-01','FSZEK/1116152227-2',to_date('2016-08-27','YYYY-Mm-DD'),'5',null,'600'); Insert into BORROWING (CUSTOMER_ID,BOOK_ITEM_ID,BORROWING_DATE,BORROWING_PERIOD_IN_DAYS,BRING_BACK_DATE,LATE_FEE) values ('E-2010/151020-01','FSZEK/1116152201-1',to_date('2015-12-29','YYYY-Mm-DD'),'144',null,'21200'); Insert into BORROWING (CUSTOMER_ID,BOOK_ITEM_ID,BORROWING_DATE,BORROWING_PERIOD_IN_DAYS,BRING_BACK_DATE,LATE_FEE) values ('E-2010/151020-01','FSZEK/1116152206-1',to_date('2016-01-10','YYYY-Mm-DD'),'67',null,'34000'); Insert into BORROWING (CUSTOMER_ID,BOOK_ITEM_ID,BORROWING_DATE,BORROWING_PERIOD_IN_DAYS,BRING_BACK_DATE,LATE_FEE) values ('E-2010/151020-13','FSZEK/1116152227-1',to_date('2016-02-07','YYYY-Mm-DD'),'10',to_date('2016-11-23','YYYY-Mm-DD'),'55800'); Insert into BORROWING (CUSTOMER_ID,BOOK_ITEM_ID,BORROWING_DATE,BORROWING_PERIOD_IN_DAYS,BRING_BACK_DATE,LATE_FEE) values ('E-2010/151020-34','FSZEK/1116152227-3',to_date('2015-07-10','YYYY-Mm-DD'),'133',to_date('2015-11-20','YYYY-Mm-DD'),null); Insert into BORROWING (CUSTOMER_ID,BOOK_ITEM_ID,BORROWING_DATE,BORROWING_PERIOD_IN_DAYS,BRING_BACK_DATE,LATE_FEE) values ('E-2010/151020-34','FSZEK/1116152229-2',to_date('2015-05-27','YYYY-Mm-DD'),'81',to_date('2015-08-16','YYYY-Mm-DD'),null); Insert into BORROWING (CUSTOMER_ID,BOOK_ITEM_ID,BORROWING_DATE,BORROWING_PERIOD_IN_DAYS,BRING_BACK_DATE,LATE_FEE) values ('E-2010/151020-34','FSZEK/1116152229-1',to_date('2014-12-13','YYYY-Mm-DD'),'438',to_date('2016-02-24','YYYY-Mm-DD'),null); Insert into BORROWING (CUSTOMER_ID,BOOK_ITEM_ID,BORROWING_DATE,BORROWING_PERIOD_IN_DAYS,BRING_BACK_DATE,LATE_FEE) values ('E-2010/151020-35','FSZEK/1116152236-1',to_date('2015-09-16','YYYY-Mm-DD'),'120',null,'46800'); Insert into BORROWING (CUSTOMER_ID,BOOK_ITEM_ID,BORROWING_DATE,BORROWING_PERIOD_IN_DAYS,BRING_BACK_DATE,LATE_FEE) values ('E-2010/151020-35','FSZEK/1116152227-2',to_date('2016-03-06','YYYY-Mm-DD'),'113',null,'13600'); Insert into BORROWING (CUSTOMER_ID,BOOK_ITEM_ID,BORROWING_DATE,BORROWING_PERIOD_IN_DAYS,BRING_BACK_DATE,LATE_FEE) values ('E-2010/151020-40','FSZEK/1116152236-2',to_date('2016-08-29','YYYY-Mm-DD'),'5',to_date('2016-09-03','YYYY-Mm-DD'),null); Insert into BORROWING (CUSTOMER_ID,BOOK_ITEM_ID,BORROWING_DATE,BORROWING_PERIOD_IN_DAYS,BRING_BACK_DATE,LATE_FEE) values ('E-2010/151020-42','FSZEK/1116152236-3',to_date('2015-01-14','YYYY-Mm-DD'),'469',to_date('2016-04-27','YYYY-Mm-DD'),null); Insert into BORROWING (CUSTOMER_ID,BOOK_ITEM_ID,BORROWING_DATE,BORROWING_PERIOD_IN_DAYS,BRING_BACK_DATE,LATE_FEE) values ('E-2010/151020-49','FSZEK/1116152236-4',to_date('2016-05-20','YYYY-Mm-DD'),'97',to_date('2018-08-04','YYYY-Mm-DD'),'141600'); Insert into BORROWING (CUSTOMER_ID,BOOK_ITEM_ID,BORROWING_DATE,BORROWING_PERIOD_IN_DAYS,BRING_BACK_DATE,LATE_FEE) values ('E-2010/151020-49','FSZEK/1116152236-5',to_date('2015-04-13','YYYY-Mm-DD'),'476',to_date('2018-11-28','YYYY-Mm-DD'),'169800'); Insert into BORROWING (CUSTOMER_ID,BOOK_ITEM_ID,BORROWING_DATE,BORROWING_PERIOD_IN_DAYS,BRING_BACK_DATE,LATE_FEE) values ('E-2010/151020-49','FSZEK/1116152201-3',to_date('2014-09-03','YYYY-Mm-DD'),'67',to_date('2016-04-23','YYYY-Mm-DD'),'106000'); Insert into BORROWING (CUSTOMER_ID,BOOK_ITEM_ID,BORROWING_DATE,BORROWING_PERIOD_IN_DAYS,BRING_BACK_DATE,LATE_FEE) values ('E-2010/151020-49','FSZEK/1116152202-4',to_date('2015-04-16','YYYY-Mm-DD'),'21',to_date('2015-08-22','YYYY-Mm-DD'),'21200'); Insert into BORROWING (CUSTOMER_ID,BOOK_ITEM_ID,BORROWING_DATE,BORROWING_PERIOD_IN_DAYS,BRING_BACK_DATE,LATE_FEE) values ('E-2010/151020-49','FSZEK/1116152212-4',to_date('2016-06-15','YYYY-Mm-DD'),'65',to_date('2017-09-04','YYYY-Mm-DD'),'76000'); Insert into BORROWING (CUSTOMER_ID,BOOK_ITEM_ID,BORROWING_DATE,BORROWING_PERIOD_IN_DAYS,BRING_BACK_DATE,LATE_FEE) values ('E-2010/151020-49','FSZEK/1116152202-5',to_date('2015-11-28','YYYY-Mm-DD'),'204',to_date('2018-11-24','YYYY-Mm-DD'),'177400'); Insert into BORROWING (CUSTOMER_ID,BOOK_ITEM_ID,BORROWING_DATE,BORROWING_PERIOD_IN_DAYS,BRING_BACK_DATE,LATE_FEE) values ('E-2010/151020-03','FSZEK/1116152201-2',to_date('2014-08-13','YYYY-Mm-DD'),'94',to_date('2015-04-06','YYYY-Mm-DD'),'28400'); Insert into BORROWING (CUSTOMER_ID,BOOK_ITEM_ID,BORROWING_DATE,BORROWING_PERIOD_IN_DAYS,BRING_BACK_DATE,LATE_FEE) values ('E-2010/151020-03','FSZEK/1116152224-1',to_date('2014-11-14','YYYY-Mm-DD'),'401',to_date('2018-08-14','YYYY-Mm-DD'),'193600'); Insert into BORROWING (CUSTOMER_ID,BOOK_ITEM_ID,BORROWING_DATE,BORROWING_PERIOD_IN_DAYS,BRING_BACK_DATE,LATE_FEE) values ('E-2010/151020-16','FSZEK/1116152226-2',to_date('2015-12-18','YYYY-Mm-DD'),'151',to_date('2016-05-17','YYYY-Mm-DD'),null); Insert into BORROWING (CUSTOMER_ID,BOOK_ITEM_ID,BORROWING_DATE,BORROWING_PERIOD_IN_DAYS,BRING_BACK_DATE,LATE_FEE) values ('E-2010/151020-01','FSZEK/1116152227-2',to_date('2016-08-11','YYYY-Mm-DD'),'21',to_date('2016-08-25','YYYY-Mm-DD'),null); Insert into BORROWING (CUSTOMER_ID,BOOK_ITEM_ID,BORROWING_DATE,BORROWING_PERIOD_IN_DAYS,BRING_BACK_DATE,LATE_FEE) values ('E-2010/151020-38','FSZEK/1116152236-2',to_date('2016-08-14','YYYY-Mm-DD'),'7',to_date('2016-08-15','YYYY-Mm-DD'),null); Insert into CUSTOMERS (LIBRARY_CARD_NUMBER,LAST_NAME,FIRST_NAME,BIRTH_DATE,GENDER,ADDRESS,ENROLLMENT_DATE,MEMBERSHIP_FEE,CATEGORY) values ('E-2010/151020-01','Jones','John',to_date('2000-09-09','YYYY-Mm-DD'),'m','3 Market Str., Debrecen',to_date('2005-02-13','YYYY-Mm-DD'),'1800','student'); Insert into CUSTOMERS (LIBRARY_CARD_NUMBER,LAST_NAME,FIRST_NAME,BIRTH_DATE,GENDER,ADDRESS,ENROLLMENT_DATE,MEMBERSHIP_FEE,CATEGORY) values ('E-2010/151020-02','Williams','Robert',to_date('1987-10-14','YYYY-Mm-DD'),'m','43 Hospital Str., Budapest',to_date('2003-09-25','YYYY-Mm-DD'),'3800','adult'); Insert into CUSTOMERS (LIBRARY_CARD_NUMBER,LAST_NAME,FIRST_NAME,BIRTH_DATE,GENDER,ADDRESS,ENROLLMENT_DATE,MEMBERSHIP_FEE,CATEGORY) values ('E-2010/151020-03','Evans','Linda',to_date('1979-11-17','YYYY-Mm-DD'),'f','12 Edit Avenue, Debrecen',to_date('2016-06-18','YYYY-Mm-DD'),'3800','adult'); Insert into CUSTOMERS (LIBRARY_CARD_NUMBER,LAST_NAME,FIRST_NAME,BIRTH_DATE,GENDER,ADDRESS,ENROLLMENT_DATE,MEMBERSHIP_FEE,CATEGORY) values ('E-2010/151020-04','Thomas','Melissa',to_date('1945-12-26','YYYY-Mm-DD'),'f','26 Barracks Str., Debrecen',to_date('1975-05-30','YYYY-Mm-DD'),'1500','pensioner'); Insert into CUSTOMERS (LIBRARY_CARD_NUMBER,LAST_NAME,FIRST_NAME,BIRTH_DATE,GENDER,ADDRESS,ENROLLMENT_DATE,MEMBERSHIP_FEE,CATEGORY) values ('E-2010/151020-05','Roberts','Mary',to_date('1947-01-27','YYYY-Mm-DD'),'f','1 Cemetery Sq., Debrecen',to_date('1986-01-20','YYYY-Mm-DD'),'1500','pensioner'); Insert into CUSTOMERS (LIBRARY_CARD_NUMBER,LAST_NAME,FIRST_NAME,BIRTH_DATE,GENDER,ADDRESS,ENROLLMENT_DATE,MEMBERSHIP_FEE,CATEGORY) values ('E-2010/151020-06','Lewis','David',to_date('1949-02-27','YYYY-Mm-DD'),'m','8 Moon Str., Debrecen',to_date('1991-07-14','YYYY-Mm-DD'),'1500','pensioner'); Insert into CUSTOMERS (LIBRARY_CARD_NUMBER,LAST_NAME,FIRST_NAME,BIRTH_DATE,GENDER,ADDRESS,ENROLLMENT_DATE,MEMBERSHIP_FEE,CATEGORY) values ('E-2010/151020-07','Wood','Charles',to_date('1951-03-28','YYYY-Mm-DD'),'m','52 Water Tower Str., Budapest',to_date('1963-05-21','YYYY-Mm-DD'),'1500','pensioner'); Insert into CUSTOMERS (LIBRARY_CARD_NUMBER,LAST_NAME,FIRST_NAME,BIRTH_DATE,GENDER,ADDRESS,ENROLLMENT_DATE,MEMBERSHIP_FEE,CATEGORY) values ('E-2010/151020-08','White','Mark',to_date('2013-04-13','YYYY-Mm-DD'),'m','44 Winter Str., Budapest',to_date('2013-05-27','YYYY-Mm-DD'),'1000','child'); Insert into CUSTOMERS (LIBRARY_CARD_NUMBER,LAST_NAME,FIRST_NAME,BIRTH_DATE,GENDER,ADDRESS,ENROLLMENT_DATE,MEMBERSHIP_FEE,CATEGORY) values ('E-2010/151020-09','Jackson','Steven',to_date('2007-05-16','YYYY-Mm-DD'),'m','34/A Sun Str., Budapest',to_date('2013-11-25','YYYY-Mm-DD'),'1000','child'); Insert into CUSTOMERS (LIBRARY_CARD_NUMBER,LAST_NAME,FIRST_NAME,BIRTH_DATE,GENDER,ADDRESS,ENROLLMENT_DATE,MEMBERSHIP_FEE,CATEGORY) values ('E-2010/151020-10','Cooper','Joshua',to_date('1999-09-10','YYYY-Mm-DD'),'m','34/B Sun Str., Budapest',to_date('1999-12-31','YYYY-Mm-DD'),'1800','student'); Insert into CUSTOMERS (LIBRARY_CARD_NUMBER,LAST_NAME,FIRST_NAME,BIRTH_DATE,GENDER,ADDRESS,ENROLLMENT_DATE,MEMBERSHIP_FEE,CATEGORY) values ('E-2010/151020-11','Morgan','Emma',to_date('1999-10-11','YYYY-Mm-DD'),'f','34/C Sun Str., Budapest',to_date('2014-11-09','YYYY-Mm-DD'),'1800','student'); Insert into CUSTOMERS (LIBRARY_CARD_NUMBER,LAST_NAME,FIRST_NAME,BIRTH_DATE,GENDER,ADDRESS,ENROLLMENT_DATE,MEMBERSHIP_FEE,CATEGORY) values ('E-2010/151020-12','Scott','Edward',to_date('1999-11-12','YYYY-Mm-DD'),'m','34/D Sun Str., Budapest',to_date('2009-05-28','YYYY-Mm-DD'),'1800','student'); Insert into CUSTOMERS (LIBRARY_CARD_NUMBER,LAST_NAME,FIRST_NAME,BIRTH_DATE,GENDER,ADDRESS,ENROLLMENT_DATE,MEMBERSHIP_FEE,CATEGORY) values ('E-2010/151020-13','Turner','James',to_date('1972-12-19','YYYY-Mm-DD'),'m','6/1 Market Str., Debrecen',to_date('1999-02-27','YYYY-Mm-DD'),'800','supporter'); Insert into CUSTOMERS (LIBRARY_CARD_NUMBER,LAST_NAME,FIRST_NAME,BIRTH_DATE,GENDER,ADDRESS,ENROLLMENT_DATE,MEMBERSHIP_FEE,CATEGORY) values ('E-2010/151020-14','Campbell','Emma',to_date('1958-01-24','YYYY-Mm-DD'),'f','6/2 Market Str., Debrecen',to_date('1968-04-15','YYYY-Mm-DD'),'1200','with discount'); Insert into CUSTOMERS (LIBRARY_CARD_NUMBER,LAST_NAME,FIRST_NAME,BIRTH_DATE,GENDER,ADDRESS,ENROLLMENT_DATE,MEMBERSHIP_FEE,CATEGORY) values ('E-2010/151020-15','Smith','James',to_date('1958-02-25','YYYY-Mm-DD'),'m','6/3 Market Str., Debrecen',to_date('1987-11-29','YYYY-Mm-DD'),'1200','with discount'); Insert into CUSTOMERS (LIBRARY_CARD_NUMBER,LAST_NAME,FIRST_NAME,BIRTH_DATE,GENDER,ADDRESS,ENROLLMENT_DATE,MEMBERSHIP_FEE,CATEGORY) values ('E-2010/151020-16','Smith','Lisa',to_date('1973-03-22','YYYY-Mm-DD'),'f','6/4 Market Str., Debrecen',to_date('2005-09-29','YYYY-Mm-DD'),'800','supporter'); Insert into CUSTOMERS (LIBRARY_CARD_NUMBER,LAST_NAME,FIRST_NAME,BIRTH_DATE,GENDER,ADDRESS,ENROLLMENT_DATE,MEMBERSHIP_FEE,CATEGORY) values ('E-2010/151020-17','Smith','Susan',to_date('1983-04-21','YYYY-Mm-DD'),'f','6/5 Market Str., Debrecen',to_date('2007-02-28','YYYY-Mm-DD'),'3800','adult'); Insert into CUSTOMERS (LIBRARY_CARD_NUMBER,LAST_NAME,FIRST_NAME,BIRTH_DATE,GENDER,ADDRESS,ENROLLMENT_DATE,MEMBERSHIP_FEE,CATEGORY) values ('E-2010/151020-18','Taylor','James',to_date('1984-05-22','YYYY-Mm-DD'),'m','3 Flower Str., London',to_date('2009-02-05','YYYY-Mm-DD'),'3800','adult'); Insert into CUSTOMERS (LIBRARY_CARD_NUMBER,LAST_NAME,FIRST_NAME,BIRTH_DATE,GENDER,ADDRESS,ENROLLMENT_DATE,MEMBERSHIP_FEE,CATEGORY) values ('E-2010/151020-19','Davies','Thomas',to_date('2002-06-18','YYYY-Mm-DD'),'m','11 Shepherd Sq., London',to_date('2015-12-24','YYYY-Mm-DD'),'1800','student'); Insert into CUSTOMERS (LIBRARY_CARD_NUMBER,LAST_NAME,FIRST_NAME,BIRTH_DATE,GENDER,ADDRESS,ENROLLMENT_DATE,MEMBERSHIP_FEE,CATEGORY) values ('E-2010/151020-20','Roberts','Sandra',to_date('1973-10-17','YYYY-Mm-DD'),'f','36 Barracks Str., London',to_date('1989-08-16','YYYY-Mm-DD'),'800','supporter'); Insert into CUSTOMERS (LIBRARY_CARD_NUMBER,LAST_NAME,FIRST_NAME,BIRTH_DATE,GENDER,ADDRESS,ENROLLMENT_DATE,MEMBERSHIP_FEE,CATEGORY) values ('E-2010/151020-21','Johnson','Rose',to_date('1941-11-26','YYYY-Mm-DD'),'f','4 Barracks Str., Berlin',to_date('1963-12-26','YYYY-Mm-DD'),'1500','pensioner'); Insert into CUSTOMERS (LIBRARY_CARD_NUMBER,LAST_NAME,FIRST_NAME,BIRTH_DATE,GENDER,ADDRESS,ENROLLMENT_DATE,MEMBERSHIP_FEE,CATEGORY) values ('E-2010/151020-22','Thompson','Mary',to_date('1937-12-28','YYYY-Mm-DD'),'f','15 Drum Str., Berlin',to_date('1940-11-18','YYYY-Mm-DD'),'1500','pensioner'); Insert into CUSTOMERS (LIBRARY_CARD_NUMBER,LAST_NAME,FIRST_NAME,BIRTH_DATE,GENDER,ADDRESS,ENROLLMENT_DATE,MEMBERSHIP_FEE,CATEGORY) values ('E-2010/151020-23','White','Mary',to_date('1994-01-15','YYYY-Mm-DD'),'f','32 School Sq., Baghdad',to_date('2005-01-02','YYYY-Mm-DD'),'1800','student'); Insert into CUSTOMERS (LIBRARY_CARD_NUMBER,LAST_NAME,FIRST_NAME,BIRTH_DATE,GENDER,ADDRESS,ENROLLMENT_DATE,MEMBERSHIP_FEE,CATEGORY) values ('E-2010/151020-24','Watson','Rebecca',to_date('1956-02-26','YYYY-Mm-DD'),'f','56 Steven Str., Tokyo',to_date('1993-06-30','YYYY-Mm-DD'),'1200','with discount'); Insert into CUSTOMERS (LIBRARY_CARD_NUMBER,LAST_NAME,FIRST_NAME,BIRTH_DATE,GENDER,ADDRESS,ENROLLMENT_DATE,MEMBERSHIP_FEE,CATEGORY) values ('E-2010/151020-25','James','Matthew',to_date('1969-03-23','YYYY-Mm-DD'),'m','103 Dew Str., Paris',to_date('1982-07-19','YYYY-Mm-DD'),'800','supporter'); Insert into CUSTOMERS (LIBRARY_CARD_NUMBER,LAST_NAME,FIRST_NAME,BIRTH_DATE,GENDER,ADDRESS,ENROLLMENT_DATE,MEMBERSHIP_FEE,CATEGORY) values ('E-2010/151020-26','Hill','Paul',to_date('1985-04-20','YYYY-Mm-DD'),'m','18 Hill Avenue, Paris',to_date('1992-04-02','YYYY-Mm-DD'),'3800','adult'); Insert into CUSTOMERS (LIBRARY_CARD_NUMBER,LAST_NAME,FIRST_NAME,BIRTH_DATE,GENDER,ADDRESS,ENROLLMENT_DATE,MEMBERSHIP_FEE,CATEGORY) values ('E-2010/151020-27','Harrison','Andrew',to_date('1966-05-26','YYYY-Mm-DD'),'m','23 Mason Str., Bern',to_date('1979-04-19','YYYY-Mm-DD'),'3800','adult'); Insert into CUSTOMERS (LIBRARY_CARD_NUMBER,LAST_NAME,FIRST_NAME,BIRTH_DATE,GENDER,ADDRESS,ENROLLMENT_DATE,MEMBERSHIP_FEE,CATEGORY) values ('E-2010/151020-28','Morris','Janet',to_date('1956-06-30','YYYY-Mm-DD'),'f','17 Honey Str., Bern',to_date('1983-09-01','YYYY-Mm-DD'),'800','supporter'); Insert into CUSTOMERS (LIBRARY_CARD_NUMBER,LAST_NAME,FIRST_NAME,BIRTH_DATE,GENDER,ADDRESS,ENROLLMENT_DATE,MEMBERSHIP_FEE,CATEGORY) values ('E-2010/151020-29','Turner','Emma',to_date('1971-07-27','YYYY-Mm-DD'),'f','8 Railway Close, Bern',to_date('2007-10-13','YYYY-Mm-DD'),'3800','adult'); Insert into CUSTOMERS (LIBRARY_CARD_NUMBER,LAST_NAME,FIRST_NAME,BIRTH_DATE,GENDER,ADDRESS,ENROLLMENT_DATE,MEMBERSHIP_FEE,CATEGORY) values ('E-2010/151020-30','Carter','Judy',to_date('1943-11-26','YYYY-Mm-DD'),'f','6 Cork Str., Moscow',to_date('1977-03-18','YYYY-Mm-DD'),'1500','pensioner'); Insert into CUSTOMERS (LIBRARY_CARD_NUMBER,LAST_NAME,FIRST_NAME,BIRTH_DATE,GENDER,ADDRESS,ENROLLMENT_DATE,MEMBERSHIP_FEE,CATEGORY) values ('E-2010/151020-31','Anderson','Ronald',to_date('1980-12-17','YYYY-Mm-DD'),'m','55 Wine Str., Madrid',to_date('1987-06-06','YYYY-Mm-DD'),'3800','adult'); Insert into CUSTOMERS (LIBRARY_CARD_NUMBER,LAST_NAME,FIRST_NAME,BIRTH_DATE,GENDER,ADDRESS,ENROLLMENT_DATE,MEMBERSHIP_FEE,CATEGORY) values ('E-2010/151020-32','Adams','Susan',to_date('2002-01-13','YYYY-Mm-DD'),'f','53 Academy Str., Madrid',to_date('2014-09-11','YYYY-Mm-DD'),'1800','student'); Insert into CUSTOMERS (LIBRARY_CARD_NUMBER,LAST_NAME,FIRST_NAME,BIRTH_DATE,GENDER,ADDRESS,ENROLLMENT_DATE,MEMBERSHIP_FEE,CATEGORY) values ('E-2010/151020-33','Phillips','Edward',to_date('1976-02-21','YYYY-Mm-DD'),'m','38 Market Str., Baghdad',to_date('2014-07-18','YYYY-Mm-DD'),'3800','adult'); Insert into CUSTOMERS (LIBRARY_CARD_NUMBER,LAST_NAME,FIRST_NAME,BIRTH_DATE,GENDER,ADDRESS,ENROLLMENT_DATE,MEMBERSHIP_FEE,CATEGORY) values ('E-2010/151020-34','Turner','George',to_date('1976-03-22','YYYY-Mm-DD'),'m','39/A Market Str., Baghdad',to_date('1977-11-02','YYYY-Mm-DD'),'3800','adult'); Insert into CUSTOMERS (LIBRARY_CARD_NUMBER,LAST_NAME,FIRST_NAME,BIRTH_DATE,GENDER,ADDRESS,ENROLLMENT_DATE,MEMBERSHIP_FEE,CATEGORY) values ('E-2010/151020-35','Young','Mark',to_date('1994-04-18','YYYY-Mm-DD'),'m','39/B Iron Gate Str., Abuja',to_date('2000-08-13','YYYY-Mm-DD'),'1800','student'); Insert into CUSTOMERS (LIBRARY_CARD_NUMBER,LAST_NAME,FIRST_NAME,BIRTH_DATE,GENDER,ADDRESS,ENROLLMENT_DATE,MEMBERSHIP_FEE,CATEGORY) values ('E-2010/151020-36','Clark','Sarah',to_date('1994-05-19','YYYY-Mm-DD'),'f','39/C Iron Gate Str., Abuja',to_date('1996-10-04','YYYY-Mm-DD'),'1800','student'); Insert into CUSTOMERS (LIBRARY_CARD_NUMBER,LAST_NAME,FIRST_NAME,BIRTH_DATE,GENDER,ADDRESS,ENROLLMENT_DATE,MEMBERSHIP_FEE,CATEGORY) values ('E-2010/151020-37','Moore','Betty',to_date('1997-06-19','YYYY-Mm-DD'),'f','4 Edit Avenue, Hanoi',to_date('2013-01-03','YYYY-Mm-DD'),'1800','student'); Insert into CUSTOMERS (LIBRARY_CARD_NUMBER,LAST_NAME,FIRST_NAME,BIRTH_DATE,GENDER,ADDRESS,ENROLLMENT_DATE,MEMBERSHIP_FEE,CATEGORY) values ('E-2010/151020-38','Martin','Lisa',to_date('1938-08-05','YYYY-Mm-DD'),'f','51 Captain Str., Cairo',to_date('1958-05-17','YYYY-Mm-DD'),'1500','pensioner'); Insert into CUSTOMERS (LIBRARY_CARD_NUMBER,LAST_NAME,FIRST_NAME,BIRTH_DATE,GENDER,ADDRESS,ENROLLMENT_DATE,MEMBERSHIP_FEE,CATEGORY) values ('E-2010/151020-39','Lee','Daniel',to_date('1943-09-05','YYYY-Mm-DD'),'m','2 Friendship Str., Nairobi',to_date('1959-02-07','YYYY-Mm-DD'),'1500','pensioner'); Insert into CUSTOMERS (LIBRARY_CARD_NUMBER,LAST_NAME,FIRST_NAME,BIRTH_DATE,GENDER,ADDRESS,ENROLLMENT_DATE,MEMBERSHIP_FEE,CATEGORY) values ('E-2010/151020-40','King','Richard',to_date('1941-12-27','YYYY-Mm-DD'),'m','14 Boat Str., Nairobi',to_date('1957-08-05','YYYY-Mm-DD'),'1500','pensioner'); Insert into CUSTOMERS (LIBRARY_CARD_NUMBER,LAST_NAME,FIRST_NAME,BIRTH_DATE,GENDER,ADDRESS,ENROLLMENT_DATE,MEMBERSHIP_FEE,CATEGORY) values ('E-2010/151020-41','Harris','David',to_date('1996-01-15','YYYY-Mm-DD'),'m','74 Cork Str., Abuja',to_date('2016-02-10','YYYY-Mm-DD'),'1800','student'); Insert into CUSTOMERS (LIBRARY_CARD_NUMBER,LAST_NAME,FIRST_NAME,BIRTH_DATE,GENDER,ADDRESS,ENROLLMENT_DATE,MEMBERSHIP_FEE,CATEGORY) values ('E-2010/151020-42','Green','Elizabeth',to_date('1938-02-28','YYYY-Mm-DD'),'f','57/1 Sun Avenue, New York',to_date('1942-12-24','YYYY-Mm-DD'),'1500','pensioner'); Insert into CUSTOMERS (LIBRARY_CARD_NUMBER,LAST_NAME,FIRST_NAME,BIRTH_DATE,GENDER,ADDRESS,ENROLLMENT_DATE,MEMBERSHIP_FEE,CATEGORY) values ('E-2010/151020-43','White','Victoria',to_date('1993-03-17','YYYY-Mm-DD'),'f','57/2 Wheat Sq., New York',to_date('2001-07-22','YYYY-Mm-DD'),'1800','student'); Insert into CUSTOMERS (LIBRARY_CARD_NUMBER,LAST_NAME,FIRST_NAME,BIRTH_DATE,GENDER,ADDRESS,ENROLLMENT_DATE,MEMBERSHIP_FEE,CATEGORY) values ('E-2010/151020-44','Robinson','Anna',to_date('1964-04-26','YYYY-Mm-DD'),'f','72 Angel Park, New York',to_date('1979-10-07','YYYY-Mm-DD'),'800','supporter'); Insert into CUSTOMERS (LIBRARY_CARD_NUMBER,LAST_NAME,FIRST_NAME,BIRTH_DATE,GENDER,ADDRESS,ENROLLMENT_DATE,MEMBERSHIP_FEE,CATEGORY) values ('E-2010/151020-45','Walker','Sharon',to_date('1971-05-25','YYYY-Mm-DD'),'f','6 Brick Str., Riyadh',to_date('1975-02-03','YYYY-Mm-DD'),'800','supporter'); Insert into CUSTOMERS (LIBRARY_CARD_NUMBER,LAST_NAME,FIRST_NAME,BIRTH_DATE,GENDER,ADDRESS,ENROLLMENT_DATE,MEMBERSHIP_FEE,CATEGORY) values ('E-2010/151020-46','Wilson','Emily',to_date('1999-06-19','YYYY-Mm-DD'),'f','59 Oak Sq., Ottawa',to_date('2003-10-14','YYYY-Mm-DD'),'1800','student'); Insert into CUSTOMERS (LIBRARY_CARD_NUMBER,LAST_NAME,FIRST_NAME,BIRTH_DATE,GENDER,ADDRESS,ENROLLMENT_DATE,MEMBERSHIP_FEE,CATEGORY) values ('E-2010/151020-47','Brown','William',to_date('1956-08-01','YYYY-Mm-DD'),'m','1 Oak Str., Ottawa',to_date('2000-08-26','YYYY-Mm-DD'),'1200','with discount'); Insert into CUSTOMERS (LIBRARY_CARD_NUMBER,LAST_NAME,FIRST_NAME,BIRTH_DATE,GENDER,ADDRESS,ENROLLMENT_DATE,MEMBERSHIP_FEE,CATEGORY) values ('E-2010/151020-48','Smith','Emily',to_date('1971-08-28','YYYY-Mm-DD'),'f','2 Old Street, Caracas',to_date('1992-09-07','YYYY-Mm-DD'),'800','supporter'); Insert into CUSTOMERS (LIBRARY_CARD_NUMBER,LAST_NAME,FIRST_NAME,BIRTH_DATE,GENDER,ADDRESS,ENROLLMENT_DATE,MEMBERSHIP_FEE,CATEGORY) values ('E-2010/151020-49','Smith','Robert',to_date('1956-10-03','YYYY-Mm-DD'),'m','88 Steven Str., Eger',to_date('2003-10-30','YYYY-Mm-DD'),'1200','with discount'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182601','1116152201','895280'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182601','1116152202','610280'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182601','1116152203','832960'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182603','1116152204','883120'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182602','1116152205','1101620'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182603','1116152206','975460'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182603','1116152207','820040'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182601','1116152209','1236520'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182605','1116152210','1352800'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182605','1116152211','996360'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182605','1116152212','913140'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182605','1116152213','907820'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182606','1116152214','1615380'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182607','1116152215','796860'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182607','1116152216','697680'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182608','1116152218','561640'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182608','1116152219','687800'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182609','1116152220','529720'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182613','1116152221','922070'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182614','1116152221','922070'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182615','1116152222','929290'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182614','1116152222','929290'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182616','1116152223','1122140'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182617','1116152224','867540'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182618','1116152225','639603,3333333333333333333333333333333333'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182619','1116152225','639603,3333333333333333333333333333333333'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182620','1116152225','639603,3333333333333333333333333333333333'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182621','1116152225','639603,3333333333333333333333333333333333'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182622','1116152225','639603,3333333333333333333333333333333333'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182623','1116152225','639603,3333333333333333333333333333333333'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182601','1116152226','825360'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182624','1116152227','770260'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182624','1116152228','913900'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182624','1116152229','546440'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182625','1116152230','439052'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182626','1116152230','439052'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182627','1116152230','439052'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182628','1116152230','439052'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182629','1116152230','439052'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182631','1116152230','439052'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182632','1116152230','439052'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182633','1116152230','439052'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182634','1116152230','439052'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182635','1116152230','439052'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182636','1116152231','487835,5555555555555555555555555555555556'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182629','1116152231','487835,5555555555555555555555555555555556'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182631','1116152231','487835,5555555555555555555555555555555556'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182637','1116152231','487835,5555555555555555555555555555555556'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182638','1116152231','487835,5555555555555555555555555555555556'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182639','1116152231','487835,5555555555555555555555555555555556'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182640','1116152231','487835,5555555555555555555555555555555556'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182641','1116152231','487835,5555555555555555555555555555555556'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182643','1116152231','487835,5555555555555555555555555555555556'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182644','1116152232','296210'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182645','1116152232','296210'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182645','1116152233','619020'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182645','1116152234','486400'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182644','1116152235','901486,6666666666666666666666666666666667'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182646','1116152235','901486,6666666666666666666666666666666667'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182647','1116152235','901486,6666666666666666666666666666666667'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182644','1116152236','456000'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182648','1116152237','3466360'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182649','1116152238','1043100'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182650','1116152238','1043100'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182651','1116152239','4186840'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182652','1116152240','1023150'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182653','1116152240','1023150'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182654','1116152241','2240860'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182654','1116152242','3562500'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182655','1116152243','607620'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182656','1116152243','607620'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182657','1116152243','607620'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182658','1116152243','607620'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182655','1116152244','608095'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182656','1116152244','608095'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182657','1116152244','608095'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182658','1116152244','608095'); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182604','1116152208',null); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182608','1116152217',null); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182611','1116152220',null); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182630','1116152230',null); Insert into WRITING (AUTHOR_ID,BOOK_ID,ROYALTY) values ('2005182642','1116152231',null); ALTER TABLE AUTHORS ADD CONSTRAINT AUTHOR_PK PRIMARY KEY (AUTHOR_ID); ALTER TABLE BOOK_ITEMS ADD CONSTRAINT BOOK_ITEM_PK PRIMARY KEY (BOOK_ITEM_ID); ALTER TABLE BOOK_ITEMS MODIFY (BOOK_ID CONSTRAINT BOOK_ITEM_BOOK_ID_NN NOT NULL ); ALTER TABLE BOOKS ADD CONSTRAINT BOOK_ISBN_UQ UNIQUE (ISBN); ALTER TABLE BOOKS ADD CONSTRAINT BOOK_PK PRIMARY KEY (BOOK_ID); ALTER TABLE BOOKS MODIFY (TITLE CONSTRAINT BOOK_TITLE_NN NOT NULL ); ALTER TABLE BORROWING ADD CONSTRAINT BORROWING_PK PRIMARY KEY (CUSTOMER_ID, BOOK_ITEM_ID, BORROWING_DATE); ALTER TABLE CUSTOMERS ADD CONSTRAINT CUSTOMER_PK PRIMARY KEY (LIBRARY_CARD_NUMBER); ALTER TABLE WRITING ADD CONSTRAINT WRITING_PK PRIMARY KEY (AUTHOR_ID, BOOK_ID); ALTER TABLE BOOK_ITEMS ADD CONSTRAINT BOOK_ITEM_TO_BOOK_FK FOREIGN KEY (BOOK_ID) REFERENCES BOOKS (BOOK_ID) ; ALTER TABLE BORROWING ADD CONSTRAINT BORROWING_TO_BOOK_ITEM_FK FOREIGN KEY (BOOK_ITEM_ID) REFERENCES BOOK_ITEMS (BOOK_ITEM_ID) ; ALTER TABLE BORROWING ADD CONSTRAINT BORROWING_TO_CUSTOMER_FK FOREIGN KEY (CUSTOMER_ID) REFERENCES CUSTOMERS (LIBRARY_CARD_NUMBER) ; ALTER TABLE WRITING ADD CONSTRAINT WRITING_TO_AUTHOR_FK FOREIGN KEY (AUTHOR_ID) REFERENCES AUTHORS (AUTHOR_ID) ; ALTER TABLE WRITING ADD CONSTRAINT WRITING_TO_BOOK_FK FOREIGN KEY (BOOK_ID) REFERENCES BOOKS (BOOK_ID) ;