CREATE TABLE Author (AuthorNum DECIMAL(2,0) PRIMARY KEY,AuthorLast CHAR(12),AuthorFirst CHAR(10) ); CREATE TABLE Book (B

[answerhappygod]

CREATE TABLE Author (AuthorNum DECIMAL(2,0) PRIMARY KEY,AuthorLast CHAR(12),AuthorFirst CHAR(10) );
CREATE TABLE Book (BookCode CHAR(4) PRIMARY KEY,Title CHAR(40),PublisherCode CHAR(3),Type CHAR(3),Paperback CHAR(1) );
CREATE TABLE Branch (BranchNum DECIMAL(2,0) PRIMARY KEY,BranchName CHAR(50),BranchLocation CHAR(50) );
CREATE TABLE Copy(BookCode CHAR(4),BranchNum DECIMAL(2,0),CopyNum DECIMAL(2,0),Quality CHAR(20),Price DECIMAL(8,2),PRIMARY KEY (BookCode, BranchNum, CopyNum) );
CREATE TABLE Publisher (PublisherCode CHAR(3) PRIMARY KEY,PublisherName CHAR(25),City CHAR(20) );
CREATE TABLE Wrote (BookCode CHAR(4),AuthorNum DECIMAL(2,0),Sequence DECIMAL(2,0),PRIMARY KEY (BookCode, AuthorNum) );
INSERT INTO AuthorVALUES(1,'Morrison','Toni');INSERT INTO AuthorVALUES(2,'Solotaroff','Paul');INSERT INTO AuthorVALUES(3,'Vintage','Vernor');INSERT INTO AuthorVALUES(4,'Francis','Dick');INSERT INTO AuthorVALUES(5,'Straub','Peter');INSERT INTO AuthorVALUES(6,'King','Stephen');INSERT INTO AuthorVALUES(7,'Pratt','Philip');INSERT INTO AuthorVALUES(8,'Chase','Truddi');INSERT INTO AuthorVALUES(9,'Collins','Bradley');INSERT INTO AuthorVALUES(10,'Heller','Joseph');INSERT INTO AuthorVALUES(11,'Wills','Gary');INSERT INTO AuthorVALUES(12,'Hofstadter','Douglas R.');INSERT INTO AuthorVALUES(13,'Lee','Harper');INSERT INTO AuthorVALUES(14,'Ambrose','Stephen E.');INSERT INTO AuthorVALUES(15,'Rowling','J.K.');INSERT INTO AuthorVALUES(16,'Salinger','J.D.');INSERT INTO AuthorVALUES(17,'Heaney','Seamus');INSERT INTO AuthorVALUES(18,'Camus','Albert');INSERT INTO AuthorVALUES(19,'Collins, Jr.','Bradley');INSERT INTO AuthorVALUES(20,'Steinbeck','John');INSERT INTO AuthorVALUES(21,'Castelman','Riva');INSERT INTO AuthorVALUES(22,'Owen','Barbara');INSERT INTO AuthorVALUES(23,'O''Rourke','Randy');INSERT INTO AuthorVALUES(24,'Kidder','Tracy');INSERT INTO AuthorVALUES(25,'Schleining','Lon');INSERT INTO BookVALUES('0180','A Deepness in the Sky','TB','SFI','Y');INSERT INTO BookVALUES('0189','Magic Terror','FA','HOR','Y');INSERT INTO BookVALUES('0200','The Stranger','VB','FIC','Y');INSERT INTO BookVALUES('0378','Venice','SS','ART','N');INSERT INTO BookVALUES('079X','Second Wind','PU','MYS','N');INSERT INTO BookVALUES('0808','The Edge','JP','MYS','Y');INSERT INTO BookVALUES('1351','Dreamcatcher: A Novel','SC','HOR','N');INSERT INTO BookVALUES('1382','Treasure Chests','TA','ART','N');INSERT INTO BookVALUES('138X','Beloved','PL','FIC','Y');INSERT INTO BookVALUES('2226','Harry Potter and the Prisoner of Azkaban','ST','SFI','N');INSERT INTO BookVALUES('2281','Van Gogh and Gauguin','WP','ART','N');INSERT INTO BookVALUES('2766','Of Mice and Men','PE','FIC','Y');INSERT INTO BookVALUES('2908','Electric Light','FS','POE','N');INSERT INTO BookVALUES('3350','Group: Six People in Search of a Life','BP','PSY','Y');INSERT INTO BookVALUES('3743','Nine Stories','LB','FIC','Y');INSERT INTO BookVALUES('3906','The Soul of a New Machine','BY','SCI','Y');INSERT INTO BookVALUES('5163','Travels with Charley','PE','TRA','Y');INSERT INTO BookVALUES('5790','Catch-22','SC','FIC','Y');INSERT INTO BookVALUES('6128','Jazz','PL','FIC','Y');INSERT INTO BookVALUES('6328','Band of Brothers','TO','HIS','Y');INSERT INTO BookVALUES('669X','A Guide to SQL','CT','CMP','Y');INSERT INTO BookVALUES('6908','Franny and Zooey','LB','FIC','Y');INSERT INTO BookVALUES('7405','East of Eden','PE','FIC','Y');INSERT INTO BookVALUES('7443','Harry Potter and the Goblet of Fire','ST','SFI','N');INSERT INTO BookVALUES('7559','The Fall','VB','FIC','Y');INSERT INTO BookVALUES('8092','Godel, Escher, Bach','BA','PHI','Y');INSERT INTO BookVALUES('8720','When Rabbit Howls','JP','PSY','Y');INSERT INTO BookVALUES('9611','Black House','RH','HOR','N');INSERT INTO BookVALUES('9627','Song of Solomon','PL','FIC','Y');INSERT INTO BookVALUES('9701','The Grapes of Wrath','PE','FIC','Y');INSERT INTO BookVALUES('9882','Slay Ride','JP','MYS','Y');INSERT INTO BookVALUES('9883','The Catcher in the Rye','LB','FIC','Y');INSERT INTO BookVALUES('9931','To Kill a Mockingbird','HC','FIC','N');INSERT INTO BranchVALUES(1,'Feisty Downtown','16 Riverview');INSERT INTO BranchVALUES(2,'Feisty on the Hill','1289 Bedford');INSERT INTO BranchVALUES(3,'Feisty Brentwood','Brentwood Mall');INSERT INTO BranchVALUES(4,'Feisty Eastshore','Eastshore Mall');INSERT INTO CopyVALUES('0180',1,1,'Excellent',7.19);INSERT INTO CopyVALUES('0180',1,2,'Excellent',7.19);INSERT INTO CopyVALUES('0189',2,1,'Excellent',7.99);INSERT INTO CopyVALUES('0189',2,2,'Good',5.99);INSERT INTO CopyVALUES('0200',1,1,'Excellent',8.00);INSERT INTO CopyVALUES('0200',2,1,'Excellent',8.00);INSERT INTO CopyVALUES('0200',2,2,'Fair',3.50);INSERT INTO CopyVALUES('0200',2,3,'Poor',2.25);INSERT INTO CopyVALUES('0378',3,1,'Excellent',24.50);INSERT INTO CopyVALUES('0378',3,2,'Excellent',24.50);INSERT INTO CopyVALUES('079X',2,1,'Excellent',25.95);INSERT INTO CopyVALUES('079X',3,1,'Excellent',25.95);INSERT INTO CopyVALUES('079X',3,2,'Good',19.95);INSERT INTO CopyVALUES('079X',4,1,'Excellent',25.95);INSERT INTO CopyVALUES('079X',4,2,'Excellent',25.95);INSERT INTO CopyVALUES('079X',4,3,'Good',19.95);INSERT INTO CopyVALUES('0808',2,1,'Excellent',7.99);INSERT INTO CopyVALUES('1351',2,1,'Excellent',21.95);INSERT INTO CopyVALUES('1351',2,2,'Excellent',21.95);INSERT INTO CopyVALUES('1351',2,3,'Excellent',21.95);INSERT INTO CopyVALUES('1351',2,4,'Excellent',21.95);INSERT INTO CopyVALUES('1351',3,1,'Excellent',21.95);INSERT INTO CopyVALUES('1351',3,2,'Good',13.95);INSERT INTO CopyVALUES('1382',2,1,'Good',34.50);INSERT INTO CopyVALUES('138X',2,1,'Excellent',12.95);INSERT INTO CopyVALUES('138X',2,2,'Excellent',12.95);INSERT INTO CopyVALUES('138X',2,3,'Good',6.95);INSERT INTO CopyVALUES('2226',1,1,'Excellent',14.96);INSERT INTO CopyVALUES('2226',1,2,'Excellent',14.96);INSERT INTO CopyVALUES('2226',1,3,'Good',8.95);INSERT INTO CopyVALUES('2226',3,1,'Excellent',14.95);INSERT INTO CopyVALUES('2226',3,2,'Excellent',14.95);INSERT INTO CopyVALUES('2226',4,1,'Fair',3.95);INSERT INTO CopyVALUES('2281',4,1,'Excellent',21.00);INSERT INTO CopyVALUES('2766',3,1,'Excellent',7.95);INSERT INTO CopyVALUES('2766',3,2,'Good',3.95);INSERT INTO CopyVALUES('2908',1,1,'Excellent',14.95);INSERT INTO CopyVALUES('2908',1,2,'Excellent',14.95);INSERT INTO CopyVALUES('2908',1,3,'Good',8.50);INSERT INTO CopyVALUES('2908',4,1,'Good',8.50);INSERT INTO CopyVALUES('3350',1,1,'Excellent',10.40);INSERT INTO CopyVALUES('3350',1,2,'Excellent',10.40);INSERT INTO CopyVALUES('3743',2,1,'Excellent',5.99);INSERT INTO CopyVALUES('3906',2,1,'Excellent',12.16);INSERT INTO CopyVALUES('3906',3,1,'Excellent',12.16);INSERT INTO CopyVALUES('3906',3,2,'Good',4.50);INSERT INTO CopyVALUES('5163',1,1,'Excellent',7.95);INSERT INTO CopyVALUES('5790',4,1,'Excellent',12.00);INSERT INTO CopyVALUES('5790',4,2,'Good',5.95);INSERT INTO CopyVALUES('6128',2,1,'Excellent',12.95);INSERT INTO CopyVALUES('6128',2,2,'Excellent',12.95);INSERT INTO CopyVALUES('6128',2,3,'Excellent',12.95);INSERT INTO CopyVALUES('6128',2,4,'Excellent',12.95);INSERT INTO CopyVALUES('6128',3,1,'Excellent',12.95);INSERT INTO CopyVALUES('6128',3,2,'Excellent',12.95);INSERT INTO CopyVALUES('6128',3,3,'Good',4.75);INSERT INTO CopyVALUES('6328',2,1,'Excellent',9.95);INSERT INTO CopyVALUES('6328',2,2,'Excellent',9.95);INSERT INTO CopyVALUES('669X',1,1,'Excellent',39.95);INSERT INTO CopyVALUES('669X',2,1,'Excellent',39.95);INSERT INTO CopyVALUES('6908',2,1,'Excellent',5.99);INSERT INTO CopyVALUES('6908',2,2,'Excellent',5.99);INSERT INTO CopyVALUES('7405',3,1,'Good',5.00);INSERT INTO CopyVALUES('7405',3,2,'Fair',2.95);INSERT INTO CopyVALUES('7443',4,1,'Good',9.25);INSERT INTO CopyVALUES('7559',2,1,'Fair',3.65);INSERT INTO CopyVALUES('7559',2,2,'Good',8.00);INSERT INTO CopyVALUES('8092',3,1,'Good',9.50);INSERT INTO CopyVALUES('8720',1,1,'Excellent',6.29);INSERT INTO CopyVALUES('8720',1,2,'Excellent',6.29);INSERT INTO CopyVALUES('8720',1,3,'Good',3.95);INSERT INTO CopyVALUES('9611',1,1,'Excellent',18.81);INSERT INTO CopyVALUES('9611',1,2,'Good',8.25);INSERT INTO CopyVALUES('9627',3,1,'Excellent',14.00);INSERT INTO CopyVALUES('9627',3,2,'Excellent',14.00);INSERT INTO CopyVALUES('9627',3,3,'Excellent',14.00);INSERT INTO CopyVALUES('9627',3,4,'Excellent',14.00);INSERT INTO CopyVALUES('9627',3,5,'Good',6.50);INSERT INTO CopyVALUES('9627',4,1,'Excellent',14.00);INSERT INTO CopyVALUES('9627',4,2,'Good',6.50);INSERT INTO CopyVALUES('9701',1,1,'Excellent',13.00);INSERT INTO CopyVALUES('9701',1,2,'Excellent',13.00);INSERT INTO CopyVALUES('9701',2,1,'Excellent',13.00);INSERT INTO CopyVALUES('9701',3,1,'Fair',4.00);INSERT INTO CopyVALUES('9701',3,2,'Fair',4.00);INSERT INTO CopyVALUES('9701',3,3,'Good',7.25);INSERT INTO CopyVALUES('9701',4,1,'Excellent',13.00);INSERT INTO CopyVALUES('9701',4,2,'Poor',1.55);INSERT INTO CopyVALUES('9882',3,1,'Excellent',6.99);INSERT INTO CopyVALUES('9882',3,2,'Good',3.75);INSERT INTO CopyVALUES('9882',3,3,'Excellent',6.99);INSERT INTO CopyVALUES('9883',2,1,'Excellent',5.99);INSERT INTO CopyVALUES('9883',2,2,'Excellent',5.99);INSERT INTO CopyVALUES('9883',2,3,'Fair',1.95);INSERT INTO CopyVALUES('9883',4,1,'Good',3.99);INSERT INTO CopyVALUES('9883',4,2,'Excellent',5.99);INSERT INTO CopyVALUES('9931',1,1,'Excellent',13.00);INSERT INTO CopyVALUES('9931',1,2,'Excellent',13.00);INSERT INTO PublisherVALUES('AH','Arkham House','Sauk City WI');INSERT INTO PublisherVALUES('AP','Arcade Publishing','New York');INSERT INTO PublisherVALUES('BA','Basic Books','Boulder CO');INSERT INTO PublisherVALUES('BP','Berkley Publishing','Boston');INSERT INTO PublisherVALUES('BY','Back Bay Books','New York');INSERT INTO PublisherVALUES('CT','Course Technology','Boston');INSERT INTO PublisherVALUES('FA','Fawcett Books','New York');INSERT INTO PublisherVALUES('FS','Farrar Straus and Giroux','New York');INSERT INTO PublisherVALUES('HC','HarperCollins Publishers','New York');INSERT INTO PublisherVALUES('JP','Jove Publications','New York');INSERT INTO PublisherVALUES('JT','Jeremy P. Tarcher','Los Angeles');INSERT INTO PublisherVALUES('LB','Lb Books','New York');INSERT INTO PublisherVALUES('MP','McPherson and Co.','Kingston');INSERT INTO PublisherVALUES('PE','Penguin USA','New York');INSERT INTO PublisherVALUES('PL','Plume','New York');INSERT INTO PublisherVALUES('PU','Putnam Publishing Group','New York');INSERT INTO PublisherVALUES('RH','Random House','New York');INSERT INTO PublisherVALUES('SB','Schoken Books','New York');INSERT INTO PublisherVALUES('SC','Scribner','New York');INSERT INTO PublisherVALUES('SS','Simon and Schuster','New York');INSERT INTO PublisherVALUES('ST','Scholastic Trade','New York');INSERT INTO PublisherVALUES('TA','Taunton Press','Newtown CT');INSERT INTO PublisherVALUES('TB','Tor Books','New York');INSERT INTO PublisherVALUES('TH','Thames and Hudson','New York');INSERT INTO PublisherVALUES('TO','Touchstone Books','Westport CT');INSERT INTO PublisherVALUES('VB','Vintage Books','New York');INSERT INTO PublisherVALUES('WN','W.W. Norton','New York');INSERT INTO PublisherVALUES('WP','Westview Press','Boulder CO');INSERT INTO WroteVALUES('0180',3,1);INSERT INTO WroteVALUES('0189',5,1);INSERT INTO WroteVALUES('0200',18,1);INSERT INTO WroteVALUES('0378',11,1);INSERT INTO WroteVALUES('079X',4,1);INSERT INTO WroteVALUES('0808',4,1);INSERT INTO WroteVALUES('1351',6,1);INSERT INTO WroteVALUES('1382',23,2);INSERT INTO WroteVALUES('1382',25,1);INSERT INTO WroteVALUES('138X',1,1);INSERT INTO WroteVALUES('2226',15,1);INSERT INTO WroteVALUES('2281',9,2);INSERT INTO WroteVALUES('2281',19,1);INSERT INTO WroteVALUES('2766',20,1);INSERT INTO WroteVALUES('2908',17,1);INSERT INTO WroteVALUES('3350',2,1);INSERT INTO WroteVALUES('3743',16,1);INSERT INTO WroteVALUES('3906',24,1);INSERT INTO WroteVALUES('5163',20,1);INSERT INTO WroteVALUES('5790',10,1);INSERT INTO WroteVALUES('6128',1,1);INSERT INTO WroteVALUES('6328',14,1);INSERT INTO WroteVALUES('669X',7,1);INSERT INTO WroteVALUES('6908',16,1);INSERT INTO WroteVALUES('7405',20,1);INSERT INTO WroteVALUES('7443',15,1);INSERT INTO WroteVALUES('7559',18,1);INSERT INTO WroteVALUES('8092',12,1);INSERT INTO WroteVALUES('8720',8,1);INSERT INTO WroteVALUES('9611',5,2);INSERT INTO WroteVALUES('9611',6,1);INSERT INTO WroteVALUES('9627',1,1);INSERT INTO WroteVALUES('9701',20,1);INSERT INTO WroteVALUES('9882',4,1);INSERT INTO WroteVALUES('9883',16,1);INSERT INTO WroteVALUES('9931',13,1);