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) ;