
CREATE TABLE publishers (
	publisherID INTEGER NOT NULL,
	publisherName varchar (30) NOT NULL,
) 
;

CREATE TABLE authors (
	authorID INTEGER NOT NULL,
	firstName varchar (20) NOT NULL,
	lastName varchar (30) NOT NULL,

) 
;

CREATE TABLE titles (
	isbn varchar (20) NOT NULL,
	title varchar (100) NOT NULL,
	editionNumber INTEGER NOT NULL,
	copyright varchar (4) NOT NULL,
	publisherID INTEGER NOT NULL,
	imageFile varchar (20) NOT NULL,
	price DOUBLE NOT NULL,

) 
;
CREATE TABLE authorISBN (
	authorID INTEGER NOT NULL,
	isbn varchar (20) NOT NULL,
	
) 
;

insert into publishers (publisherid,publisherName) values (1,'Prentice Hall')
;
insert into publishers (publisherid,publisherName) values (2,'Prentice Hall PTG')
;
insert into publishers (publisherid,publisherName) values (3,'Bookman')
;


insert into authors (authorID,firstName,lastName) values (1,'Harvey','Deitel')
;
insert into authors (authorID,firstName,lastName) values (2,'Paul','Deitel')
;
insert into authors (authorID,firstName,lastName) values (3,'Tem','Nieto')
;
insert into authors (authorID,firstName,lastName) values (4,'Sean','Santry')
;

insert into authors (authorID,firstName,lastName) values (5,'Cay','Horstmann')
;

insert into authors (authorID,firstName,lastName) values (6,'Gary','Cornell')
;


insert into titles (isbn,title,editionNumber,copyright,publisherID,imageFile,price) values ('047124371X','Conceitos de Computacao com Java',1,'2003',3,'essencial.jpg',95.00);

insert into titles (isbn,title,editionNumber,copyright,publisherID,imageFile,price) values ('0137081898','Core Java - Volume I - Fundamentals',9,'2013',1,'corejava1.jpg',100.00)
insert into titles (isbn,title,editionNumber,copyright,publisherID,imageFile,price) values ('0137081899','Core Java - Volume II - Advanced',9,'2013',1,'corejava1.jpg',100.00)


insert into titles (isbn,title,editionNumber,copyright,publisherID,imageFile,price) values ('0131426443','C How to Program',4,'2004',1,'chtp4.jpg',85.00)
;
insert into titles (isbn,title,editionNumber,copyright,publisherID,imageFile,price) values ('0130895725','C How to Program',3,'2001',1,'chtp3.jpg',69.95)
;
insert into titles (isbn,title,editionNumber,copyright,publisherID,imageFile,price) values ('0132261197','C How to Program',2,'1994',1,'chtp2.jpg',49.95)
;
insert into titles (isbn,title,editionNumber,copyright,publisherID,imageFile,price) values ('0130384747','C++ How to Program',4,'2003',1,'cpphtp4.jpg',85.00)
;
insert into titles (isbn,title,editionNumber,copyright,publisherID,imageFile,price) values ('0130895717','C++ How to Program',3,'2001',1,'cpphtp3.jpg',69.95)
;
insert into titles (isbn,title,editionNumber,copyright,publisherID, imageFile,price) values ('0135289106','C++ How to Program',2,'1998',1,'cpphtp2.jpg',49.95)
;
insert into titles (isbn,title,editionNumber,copyright,publisherID,imageFile,price) values ('013100252X','The Complete C++ Training Course',4,'2003',2,'cppctc4.jpg',109.99)
;
insert into titles (isbn,title,editionNumber,copyright,publisherID,imageFile,price) values ('0139163050','The Complete C++ Training Course',3,'2001',2,'cppctc3.jpg',109.95)
;
insert into titles (isbn,title,editionNumber,copyright,publisherID,imageFile,price) values ('013028419x','e-Business and e-Commerce How to Program',1,'2001',1,'ebechtp1.jpg',69.95)
;
insert into titles (isbn,title,editionNumber,copyright,publisherID,imageFile,price) values ('0131450913','Internet and World Wide Web How to Program',3,'2004',1,'iw3htp3.jpg',85.00)
;
insert into titles (isbn,title,editionNumber,copyright,publisherID,imageFile,price) values ('0130308978','Internet and World Wide Web How to Program',2,'2002',1,'iw3htp2.jpg',69.95)
;
insert into titles (isbn,title,editionNumber,copyright,publisherID,imageFile,price) values ('0130161438','Internet and World Wide Web How to Program',1,'2000',1,'iw3htp1.jpg',69.95)
;
insert into titles (isbn,title,editionNumber,copyright,publisherID,imageFile,price) values ('0130856118','The Complete Internet and World Wide Web Programming Training Course',1,'2000',2,'iw3ctc1.jpg',109.95)
;
insert into titles (isbn,title,editionNumber,copyright,publisherID,imageFile,price) values ('0131483986','Java How to Program',6,'2005',1,'jhtp6.jpg',85.00)
;
insert into titles (isbn,title,editionNumber,copyright,publisherID,imageFile,price) values ('0131016210','Java How to Program',5,'2003',1,'jhtp5.jpg',85.00)
;
insert into titles (isbn,title,editionNumber,copyright,publisherID,imageFile,price) values ('0130341517','Java How to Program',4,'2002',1,'jhtp4.jpg',85.00)
;
insert into titles (isbn,title,editionNumber,copyright,publisherID,imageFile,price) values ('0130125075','Java How to Program (Java 2)',3,'2000',1,'jhtp3.jpg',69.95)
;
insert into titles (isbn,title,editionNumber,copyright,publisherID,imageFile,price) values ('0138993947','Java How to Program (Java 1.1)',2,'1998',1,'jhtp2.jpg',49.95)
;
insert into titles (isbn,title,editionNumber,copyright,publisherID,imageFile,price) values ('0130852473','The Complete Java 2 Training Course',3,'2000',2,'javactc3.jpg',109.95)
;
insert into titles (isbn,title,editionNumber,copyright,publisherID,imageFile,price) values ('0130829277','The Complete Java Training Course (Java 1.1)',2,'1998',2,'javactc2.jpg',99.95)
;
insert into titles (isbn,title,editionNumber,copyright,publisherID,imageFile,price) values ('0134569555','Visual Basic 6 How to Program',1,'1999',1,'vbhtp1.jpg',69.95)
;
insert into titles (isbn,title,editionNumber,copyright,publisherID,imageFile,price) values ('0130829293','The Complete Visual Basic 6 Training Course',1,'1999',2,'vbctc1.jpg',109.95)
;
insert into titles (isbn,title,editionNumber,copyright,publisherID,imageFile,price) values ('0130284173','XML How to Program',1,'2001',1,'xmlhtp1.jpg',69.95)
;
insert into titles (isbn,title,editionNumber,copyright,publisherID,imageFile,price) values ('0130284181','Perl How to Program',1,'2001',1,'perlhtp1.jpg',69.95)
;
insert into titles (isbn,title,editionNumber,copyright,publisherID,imageFile,price) values ('0130895601','Advanced Java 2 Platform How to Program',1,'2002',1,'advjhtp1.jpg',69.95)
;
insert into titles (isbn,title,editionNumber,copyright,publisherID,imageFile,price) values ('0130461342','Java Web Services for Experienced Programmers',1,'2003',1,'jwsfep1.jpg',54.99)
;

insert into authorISBN (authorID,isbn) values (1,'0130895725')
;
insert into authorISBN (authorID,isbn) values (1,'0132261197')
;
insert into authorISBN (authorID,isbn) values (1,'0130895717')
;
insert into authorISBN (authorID,isbn) values (1,'0135289106')
;
insert into authorISBN (authorID,isbn) values (1,'0139163050')
;
insert into authorISBN (authorID,isbn) values (1,'013028419x')
;
insert into authorISBN (authorID,isbn) values (1,'0130161438')
;
insert into authorISBN (authorID,isbn) values (1,'0130856118')
;
insert into authorISBN (authorID,isbn) values (1,'0130125075')
;
insert into authorISBN (authorID,isbn) values (1,'0138993947')
;
insert into authorISBN (authorID,isbn) values (1,'0130852473')
;
insert into authorISBN (authorID,isbn) values (1,'0130829277')
;
insert into authorISBN (authorID,isbn) values (1,'0134569555')
;
insert into authorISBN (authorID,isbn) values (1,'0130829293')
;
insert into authorISBN (authorID,isbn) values (1,'0130284173')
;
insert into authorISBN (authorID,isbn) values (1,'0130284181')
;
insert into authorISBN (authorID,isbn) values (1,'0130895601')
;
insert into authorISBN (authorID,isbn) values (1,'0130384747')
;
insert into authorISBN (authorID,isbn) values (1,'0131426443')
;
insert into authorISBN (authorID,isbn) values (1,'013100252X')
;
insert into authorISBN (authorID,isbn) values (1,'0131450913')
;
insert into authorISBN (authorID,isbn) values (1,'0130308978')
;
insert into authorISBN (authorID,isbn) values (1,'0131483986')
;
insert into authorISBN (authorID,isbn) values (1,'0131016210')
;
insert into authorISBN (authorID,isbn) values (1,'0130341517')
;
insert into authorISBN (authorID,isbn) values (1,'0131450913')
;
insert into authorISBN (authorID,isbn) values (1,'0130308978')
;

insert into authorISBN (authorID,isbn) values (2,'0130895725')
;
insert into authorISBN (authorID,isbn) values (2,'0132261197')
;
insert into authorISBN (authorID,isbn) values (2,'0130895717')
;
insert into authorISBN (authorID,isbn) values (2,'0135289106')
;
insert into authorISBN (authorID,isbn) values (2,'0139163050')
;
insert into authorISBN (authorID,isbn) values (2,'013028419x')
;
insert into authorISBN (authorID,isbn) values (2,'0130161438')
;
insert into authorISBN (authorID,isbn) values (2,'0130856118')
;
insert into authorISBN (authorID,isbn) values (2,'0130125075')
;
insert into authorISBN (authorID,isbn) values (2,'0138993947')
;
insert into authorISBN (authorID,isbn) values (2,'0130852473')
;
insert into authorISBN (authorID,isbn) values (2,'0130829277')
;
insert into authorISBN (authorID,isbn) values (2,'0134569555')
;
insert into authorISBN (authorID,isbn) values (2,'0130829293')
;
insert into authorISBN (authorID,isbn) values (2,'0130284173')
;
insert into authorISBN (authorID,isbn) values (2,'0130284181')
;
insert into authorISBN (authorID,isbn) values (2,'0130895601')
;
insert into authorISBN (authorID,isbn) values (2,'0130384747')
;
insert into authorISBN (authorID,isbn) values (2,'0131426443')
;
insert into authorISBN (authorID,isbn) values (2,'013100252X')
;
insert into authorISBN (authorID,isbn) values (2,'0131450913')
;
insert into authorISBN (authorID,isbn) values (2,'0130308978')
;
insert into authorISBN (authorID,isbn) values (2,'0131483986')
;
insert into authorISBN (authorID,isbn) values (2,'0131016210')
;
insert into authorISBN (authorID,isbn) values (2,'0130341517')
;
insert into authorISBN (authorID,isbn) values (2,'0131450913')
;
insert into authorISBN (authorID,isbn) values (2,'0130308978')
;

insert into authorISBN (authorID,isbn) values (3,'013028419x')
;
insert into authorISBN (authorID,isbn) values (3,'0130161438')
;
insert into authorISBN (authorID,isbn) values (3,'0130856118')
;
insert into authorISBN (authorID,isbn) values (3,'0134569555')
;
insert into authorISBN (authorID,isbn) values (3,'0130829293')
;
insert into authorISBN (authorID,isbn) values (3,'0130284173')
;
insert into authorISBN (authorID,isbn) values (3,'0130284181')
;


insert into authorISBN (authorID,isbn) values (4,'0130895601')
;
insert into authorISBN (authorID,isbn) values
(5,'047124371X');
insert into authorISBN (authorID,isbn) values
(5,'0137081898');
insert into authorISBN (authorID,isbn) values
(6,'0137081898');

insert into authorISBN (authorID,isbn) values
(5,'0137081899');
insert into authorISBN (authorID,isbn) values
(6,'0137081899');

