The conflict occurred table bookauthor

BRANCH VALUE

In table BRANCH datatype for BNumber is “numeric” but here value are inserted SeqBranches.nextval i.e invalid number …. SeqBranches.nextval use if first we create the sequence…and sequence is available in Oracle only.

‘Margate’, 'FL', '33063', '9549683800');

INSERT INTO BRANCH VALUES (SeqBranches.nextval, ‘South Branch’, ‘3301 College Av’, NULL, ‘Fort Lauderdale’, ‘FL’, ‘33314’, ‘8885416682’);

BOOK VALUES

INSERT INTO BOOK VALUES (‘9780470229064’, ‘SQL Bible’, ‘Addison Wesley’, 2008, 900);

INSERT INTO BOOK VALUES (‘9780138018801’, ‘Database Concepts’, ‘Prentice Hall’, 2010, 450);

INSERT INTO BOOK VALUES (‘9781111825911’, ‘Concepts of Database Management’, ‘Cengage Learning’, 2011 , 400);

INSERT INTO BOOK VALUES (‘9780756682668’, ‘Computers’, ‘DK Publishing’, 2011,72);

INSERT INTO BOOK VALUES (‘9786134339438’, ‘Handle Computing’, ‘DK Publishing’, 2011,80);

INSERT INTO BOOK VALUES (‘9781419934148’, ‘Dominance Program’, ‘Ellora's Cave Publishing’, 2011,288);

INSERT INTO BOOK VALUES (‘9786133842663’, ‘Ajax Programming’, ‘Alphascript Publishing’, 2010,96);

INSERT INTO BOOK VALUES (‘9780312546595’, ‘Retribution’, ‘Grand Central’, 2011,448);

INSERT INTO BOOK VALUES (‘9780446547604’, ‘Safe Haven’, ‘Grand Central’, 2011,368);

INSERT INTO BOOK VALUES (‘9780385340304’, ‘Happy Birthday’,’Random House Publishing’, 2011,352);

INSERT INTO BOOK VALUES (‘9780062072184’, ‘Portrait of a Spy’,’HarperCollins’,2011,464);

INSERT INTO BOOK VALUES ('9780136003915', 'Surreal Numbers', 'Addison Wesley', 1974, 128);

INSERT INTO BOOK VALUES ('9780072262247', 'SQL Demystified', 'McGraw-Hill Companies', 2005, 312);

INSERT INTO BOOK VALUES ('9781597494243', 'SQL Injection Attacks and Defense', 'Elsevier Science',2009, 336);

INSERT INTO BOOK VALUES ('9780123735966', 'SQL Puzzles and Answers', 'Morgan Kaufmann', 1997, 200);

INSERT INTO BOOK VALUES ('9780816072859', 'Computers', 'Facts on File', 2011,208);

INSERT INTO BOOK VALUES ('9780077095840', 'Computers', 'McGraw-Hill Companies', 2000,444);

INSERT INTO BOOK VALUES ('9780525952251', 'The Ideal Man', 'Penguin Group', 2011,366);

INSERT INTO BOOK VALUES ('9780425232200', 'The Help', 'Penguin Group', 2011,544);

INSERT INTO BOOK VALUES ('9780061743528', 'To Kill a Mockingbird', 'Harper', 2010, 336);

INSERT INTO BOOK VALUES ('9780456487922', 'The Ocean Inside', 'Kensington', 2010, 336);

INSERT INTO BOOK VALUES ('9780312379148', 'Buried Secrets','St. Martins Press',2011,400);

INSERT INTO BOOK VALUES ('9780765324108', 'Abyss',' Doherty, Tom Ass',2011,496);

INSERT INTO BOOKAUTHOR VALUES (SeqAuthors.nextval, ‘Anthony’, NULL, ‘Molinaro’);

INSERT INTO BOOKAUTHOR VALUES (SeqAuthors.nextval, ‘Donald’, ‘E’, ‘Knuth’);

INSERT INTO BOOKAUTHOR VALUES (SeqAuthors.nextval, ‘Michael’, NULL, ‘Sikora’);

INSERT INTO BOOKAUTHOR VALUES (SeqAuthors.nextval, ‘Dan’, NULL, ‘Tow’);

INSERT INTO BOOKAUTHOR VALUES (SeqAuthors.nextval, ‘Marjorie’, NULL, ‘Eberts’);

INSERT INTO BOOKAUTHOR VALUES (SeqAuthors.nextval, ‘Ferguson’, NULL, ‘Ferguson’);

INSERT INTO BOOKAUTHOR VALUES (SeqAuthors.nextval, ‘Mortimer’, NULL, ‘Adle’);

INSERT INTO BOOKAUTHOR VALUES (SeqAuthors.nextval, ‘Julie’, NULL, ‘Garwood’);

INSERT INTO BOOKAUTHOR VALUES (SeqAuthors.nextval, ‘Jim’, NULL, ‘Butcher’);

INSERT INTO BOOKAUTHOR VALUES (SeqAuthors.nextval, ‘Harper’, NULL, ‘Lee’);

INSERT INTO BOOKAUTHOR VALUES (SeqAuthors.nextval, ‘Joseph’, NULL, ‘Finder’);

INSERT INTO BOOKAUTHOR VALUES (SeqAuthors.nextval, ‘David’, NULL, ‘Hagberg’);

that why the INSERT statement conflicted with the FOREIGN KEY constraint "FK_Author". The conflict occurred in table BOOKAUTHOR, column 'ANumber'.

INSERT INTO AUTHORLIST VALUES ('9780470229064', 3);

INSERT INTO AUTHORLIST VALUES ('9780138018801', 9);

INSERT INTO AUTHORLIST VALUES ('9781111825911', 2);

INSERT INTO AUTHORLIST VALUES ('9780756682668', 8);

INSERT INTO AUTHORLIST VALUES ('9786134339438', 10);

INSERT INTO AUTHORLIST VALUES ('9781419934148', 15);

INSERT INTO AUTHORLIST VALUES ('9786133842663', 16);

INSERT INTO AUTHORLIST VALUES ('9780312546595', 21);

INSERT INTO AUTHORLIST VALUES ('9780446547604', 21);

INSERT INTO AUTHORLIST VALUES (‘9780385340304', 7);

INSERT INTO AUTHORLIST VALUES (' 9780062072184', 2);

In table PATRON datatype for PNumber is “numeric” but here value are inserted SeqPatrons.nextval i.e invalid number …. SeqPatrons.nextval use if first we create the sequence…and sequence is available in Oracle only.

INSERT INTO PATRON VALUES (SeqPatrons.nextval, ‘Lawrence’,’ Rotich’, ‘1910 Lennox ln’, NULL, ‘Arlington’, ‘TX’, ‘76018’, ‘lr726@nova.edu’, ‘8178178171’);

INSERT INTO PATRON VALUES (SeqPatrons.nextval, ‘Nelly’,’Sweet’, ‘4 main st ’, NULL, ‘Ft Lauderdale’, ‘FL’, ‘33314’, ‘nsweet@yahoo.com’, ‘9146667777’);

INSERT INTO PATRON VALUES (SeqPatrons.nextval, 'Rita', 'Tom', '709 Old town st', NULL, 'Arlington', 'TX', '76018', 'rtom@att.net', 4693334444);

INSERT INTO COPYOFBOOK VALUES (SeqCopies.nextval, '009780470229064', 5.58, '2');

INSERT INTO COPYOFBOOK VALUES (SeqCopies.nextval, '009780470229064', 5.58, '2');

INSERT INTO COPYOFBOOK VALUES (SeqCopies.nextval, '009780470229064', 5.58, '5');

INSERT INTO COPYOFBOOK VALUES (SeqCopies.nextval, '009780470229064', 5.58, '6');

INSERT INTO COPYOFBOOK VALUES (SeqCopies.nextval, '009780470229064', 5.58, '12');

INSERT INTO COPYOFBOOK VALUES (SeqCopies.nextval, '009780470229064', 5.58, '13');

INSERT INTO COPYOFBOOK VALUES (SeqCopies.nextval, '097805960097620', 5.60, '2');

INSERT INTO COPYOFBOOK VALUES (SeqCopies.nextval, '097805960097620', 5.60, '2');

INSERT INTO COPYOFBOOK VALUES (SeqCopies.nextval, '097805960097620', 5.60, '9');

INSERT INTO COPYOFBOOK VALUES (SeqCopies.nextval, '097805960097620', 5.60, '14');

INSERT INTO COPYOFBOOK VALUES (SeqCopies.nextval, '9780201038125', 6.00, '6');

INSERT INTO COPYOFBOOK VALUES (SeqCopies.nextval, '9780201038125', 6.00, '7');

INSERT INTO COPYOFBOOK VALUES (SeqCopies.nextval, '9780201038125', 6.00, '13');

INSERT INTO COPYOFBOOK VALUES (SeqCopies.nextval, '9780201038125', 6.00, '14');

INSERT INTO COPYOFBOOK VALUES (SeqCopies.nextval, '9780072262247', 6.40, '6');

INSERT INTO COPYOFBOOK VALUES (SeqCopies.nextval, '9780072262247', 6.40, '7');

INSERT INTO BOOKLOAN (LNumber, CNumber, PNumber) VALUES (SeqLoans.nextval, 28, 16);

INSERT INTO BOOKLOAN (LNumber, CNumber, PNumber) VALUES (SeqLoans.nextval, 34, 16);

INSERT INTO BOOKLOAN (LNumber, CNumber, PNumber) VALUES (SeqLoans.nextval, 91, 16);

INSERT INTO BOOKLOAN (LNumber, CNumber, PNumber) VALUES (SeqLoans.nextval, 105, 16);

INSERT INTO BOOKLOAN (LNumber, CNumber, PNumber) VALUES (SeqLoans.nextval, 177, 16);

INSERT INTO BOOKLOAN (LNumber, CNumber, PNumber) VALUES (SeqLoans.nextval, 181, 16);

INSERT INTO BOOKLOAN (LNumber, CNumber, PNumber) VALUES (SeqLoans.nextval, 233, 16);

INSERT INTO BOOKLOAN (LNumber, CNumber, PNumber) VALUES (SeqLoans.nextval, 242, 16);

INSERT INTO BOOKLOAN (LNumber, CNumber, PNumber) VALUES (SeqLoans.nextval, 214, 16);

INSERT INTO BOOKLOAN (LNumber, CNumber, PNumber) VALUES (SeqLoans.nextval, 314, 16);

INSERT INTO BOOKLOAN (LNumber, CNumber, PNumber) VALUES (SeqLoans.nextval, 122, 21);

INSERT INTO BOOKLOAN (LNumber, CNumber, PNumber) VALUES (SeqLoans.nextval, 435, 22);