Insert into Books

INSERT INTO BOOK_INFO (TITLE, EDITION, DESCRIPTION, CATEGORY, FICTION, PUBLISHER_ID, AUTHOR_ID, YEAR_PUBLISHED, PAGES, BOOK_PRICE, ISBN)
VALUES ('THE YELLOW CLOUD', '1ST', 'PEOPLE SEARCH FOR THE MYSTERIOUS ORIGINS OF THE YELLOW CLOUD ABOVE TOWN', 'MYSTERY', 'FICTION', '11111', '2222', '1995', 100, 9.99, '9783161484100');
INSERT INTO BOOK_INFO (TITLE, EDITION, DESCRIPTION, CATEGORY, FICTION, PUBLISHER_ID, AUTHOR_ID, YEAR_PUBLISHED, PAGES, BOOK_PRICE, ISBN)
VALUES ('BABY AND ME', '2ND', 'A BOOK ABOUT BONDING WITH YOUR BABY', 'SELF-HELP', 'NON-FICTION', '11222', '1222', '2005', 205, 16.99, '9783161484101');
INSERT INTO BOOK_INFO (TITLE, EDITION, DESCRIPTION, CATEGORY, FICTION, PUBLISHER_ID, AUTHOR_ID, YEAR_PUBLISHED, PAGES, BOOK_PRICE, ISBN)
VALUES ('WE ARE TODAY', '2ND', 'A TIME TRAVELER FROM THE FUTURE WARNS MANDY TO PREVENT OMINOUS EVENTS', 'FANTASY', 'FICTION', '22223', '1221', '1987', 167, 5.99, '9783161484102');
INSERT INTO BOOK_INFO (TITLE, EDITION, DESCRIPTION, CATEGORY, FICTION, PUBLISHER_ID, AUTHOR_ID, YEAR_PUBLISHED, PAGES, BOOK_PRICE, ISBN)
VALUES ('ASTRONOMY', '5TH', 'INFORMATION ON THE GALAXY, THE PLANETS, AND THE STARS.', 'SCIENCE', 'NON-FICTION', '22334', '1211', '2009', 217, 25.99, '9783161484103');
INSERT INTO BOOK_INFO (TITLE, EDITION, DESCRIPTION, CATEGORY, FICTION, PUBLISHER_ID, AUTHOR_ID, YEAR_PUBLISHED, PAGES, BOOK_PRICE, ISBN)
VALUES ('THE HISTORY OF FOOD', '6TH', 'THE HISTORY OF FOODS FROM AROUND THE WORLD FROM ANCIENT TIMES TIL NOW', 'HISTORY', 'NON-FICTION', '33335', '2111', '1990', 300, 6.99, '9783161484104');




INSERT INTO AUTHOR_INFO (FIRST_NAME, LAST_NAME, BIRTH_DATE, COUNTRY, AUTHOR_ID)
VALUES ('MARTIN', 'SHEENI', "1942-05-21", 'USA', '2222');
INSERT INTO AUTHOR_INFO (FIRST_NAME, LAST_NAME, BIRTH_DATE, COUNTRY, AUTHOR_ID)
VALUES ('SIMON', 'ABRAHAM', "1967-10-10", 'USA', '1222');
INSERT INTO AUTHOR_INFO (FIRST_NAME, LAST_NAME, BIRTH_DATE, COUNTRY, AUTHOR_ID)
VALUES ('MARIA', 'PAULA', "1947-06-12", 'BRAZIL', '1221');
INSERT INTO AUTHOR_INFO (FIRST_NAME, LAST_NAME, BIRTH_DATE, COUNTRY, AUTHOR_ID)
VALUES ('JOSEPH', 'NATHANSON', "1960-11-11", 'USA', '1211');
INSERT INTO AUTHOR_INFO (FIRST_NAME, LAST_NAME, BIRTH_DATE, COUNTRY, AUTHOR_ID)
VALUES ('JACKIE', 'SMITH', "1971-12-21", 'USA', '2111');






INSERT INTO PUBLISHER_INFO (PUBLISHER_NAME, PUBLISHER_ADDRESS, PUBLISHER_COUNTRY, PUBLISHER_STATE, PUBLISHER_ID)
VALUES ('STARS INCORPORATED', '10502 MAPLE STREET', 'USA', 'OH', '22334');
INSERT INTO PUBLISHER_INFO (PUBLISHER_NAME, PUBLISHER_ADDRESS, PUBLISHER_COUNTRY, PUBLISHER_STATE, PUBLISHER_ID)
VALUES ('BRAZIL BOOKS LTD', '19677 LLAMA STREET', 'BRAZIL', 'NA', '33335');
INSERT INTO PUBLISHER_INFO (PUBLISHER_NAME, PUBLISHER_ADDRESS, PUBLISHER_COUNTRY, PUBLISHER_STATE, PUBLISHER_ID)
VALUES ('SMITHSON BOOKS', '25573 MARTIN AVE.', 'USA', 'NY', '11111');
INSERT INTO PUBLISHER_INFO (PUBLISHER_NAME, PUBLISHER_ADDRESS, PUBLISHER_COUNTRY, PUBLISHER_STATE, PUBLISHER_ID)
VALUES ('ROCKER & ROCKER', '10505 ENGLANDER', 'USA', 'MA', '11222');
INSERT INTO PUBLISHER_INFO (PUBLISHER_NAME, PUBLISHER_ADDRESS, PUBLISHER_COUNTRY, PUBLISHER_STATE, PUBLISHER_ID)
VALUES ('SUNSHINE PUBLISHING CO.', '19995 PLAINS', 'USA', 'MI', '22223');