9UUjhq8a

1DROP DATABASE IF EXISTS book;
2CREATE DATABASE book;
3use Book;
4
5CREATE TABLE Author(
6   authorID  INT,
7   LastName  VARCHAR(50) NOT NULL,
8   FirstName VARCHAR(50) NOT NULL,
9   Photo     VARCHAR(1),
10   constraint author_authorID_pk PRIMARY KEY (authorID)
11);
12
13CREATE TABLE Category(
14   CatID INT,
15   CatDescription VARCHAR(24),
16   constraint category_catID_pk PRIMARY KEY (catID)
17);
18
19CREATE TABLE State(
20   StateCode CHAR(2),
21   StateName VARCHAR(50),
22   constraint state_statecode_pk PRIMARY KEY (statecode)
23);
24
25CREATE TABLE BookCondition(
26   Rank INT,
27   Description VARCHAR(50),
28   FullDescription VARCHAR(255),
29   constraint condition_rank_pk PRIMARY KEY (rank)
30);
31
32CREATE TABLE ConditionEvaluator(
33   Evaluator CHAR(3),
34   EvaluatorsName VARCHAR(36) NOT NULL,
35   constraint condeval_evaluator_pk PRIMARY KEY (evaluator)
36);
37
38CREATE TABLE Reviewer(
39   ReviewerID INT,
40   Name VARCHAR(20) NOT NULL,
41   EmployedBy CHAR(30),
42   constraint reviewer_reviewerID_pk PRIMARY KEY (reviewerID)
43);
44
45CREATE TABLE Owner(
46   OwnerID INT,
47   LastName VARCHAR(30) NOT NULL,
48   FirstName VARCHAR(20) NOT NULL,
49   PhoneNumber CHAR(14),
50   UserName VARCHAR(30) NOT NULL,
51   Password VARCHAR(30) NOT NULL,
52   constraint owner_ownerID_pk PRIMARY KEY (ownerID)
53);
54
55CREATE TABLE Publisher(
56   PublisherID INT,
57   Name VARCHAR(50) NOT NULL,
58   City VARCHAR(30),
59   StateCode CHAR(2),
60   constraint publisher_publisherID_pk PRIMARY KEY (publisherID),
61   constraint publisher_statecode_fk FOREIGN KEY (StateCode) REFERENCES State(StateCode)
62);
63
64CREATE TABLE Book(
65   ISBN        CHAR(13),
66   Title       VARCHAR(70) NOT NULL,
67   Description VARCHAR(100),
68   Category    INT,
69   Edition     CHAR(30),
70   PublisherID INT         NOT NULL,
71   constraint book_ISBN_pk PRIMARY KEY (ISBN),
72   constraint book_category_fk FOREIGN KEY (Category) REFERENCES Category(CatID),
73   constraint book_publisherID_fk FOREIGN KEY (PublisherID) REFERENCES Publisher(PublisherID)
74);
75
76CREATE TABLE BookAuthor(
77   ISBN CHAR(13) NOT NULL,
78   AuthorID INT NOT NULL,
79   PrimaryAuthor CHAR(1),
80   constraint bookauthor_pk PRIMARY KEY (ISBN, AuthorID),
81   constraint bookauthor_ISBN_fk FOREIGN KEY (ISBN) REFERENCES Book(ISBN),
82   constraint bookauther_authorID_fk FOREIGN KEY (AuthorID) REFERENCES Author(AuthorID)
83);
84
85CREATE TABLE BookReview(
86   ISBN CHAR(13) NOT NULL,
87   ReviewerID INT NOT NULL,
88   Rating INT,
89   Comments VARCHAR(255),
90   constraint bookreview_pk PRIMARY KEY (ISBN, ReviewerID),
91   constraint bookreview_ISBN_fk FOREIGN KEY (ISBN) REFERENCES Book(ISBN),
92   constraint bookreview_reviewerID_fk FOREIGN KEY (ReviewerID) REFERENCES Reviewer(ReviewerID)
93);
94
95CREATE TABLE OwnersBook(
96   OwnerID INT NOT NULL,
97   ISBN CHAR(13) NOT NULL,
98   Rank INT,
99   Evaluator CHAR(3),
100   Comments VARCHAR(255),
101   Price DECIMAL(12,2),
102   TransactionFlag CHAR(1),
103   constraint ownersbook_pk PRIMARY KEY(OwnerID, ISBN),
104   constraint ownersbook_ownerid_fk FOREIGN KEY (OwnerID) REFERENCES Owner(OwnerID),
105   constraint ownersbook_ISBN_fk FOREIGN KEY (ISBN) REFERENCES Book(ISBN),
106   constraint ownersbook_rank_fk FOREIGN KEY (Rank) REFERENCES BookCondition(Rank),
107   constraint ownersbook_evaluator_fk FOREIGN KEY (Evaluator) REFERENCES ConditionEvaluator(Evaluator)
108);
109
110--
111-- Dumping data for table 'author'
112--
113
114INSERT INTO author VALUES (1,'Machogeek','Hero','');
115INSERT INTO author VALUES (2,'Stratton','Bill','');
116INSERT INTO author VALUES (3,'Kennedy','Dan','');
117INSERT INTO author VALUES (4,'Sonstein','Jeff','');
118INSERT INTO author VALUES (5,'Troell','Luther','');
119INSERT INTO author VALUES (6,'Lutz','Peter','');
120INSERT INTO author VALUES (7,'Heartthrob','Danielle','');
121INSERT INTO author VALUES (8,'Lawley','Elizabeth','');
122INSERT INTO author VALUES (9,'Weeden','Elissa','');
123INSERT INTO author VALUES (10,'Johnson','Daryl','');
124INSERT INTO author VALUES (11,'Garrison','Dan','');
125INSERT INTO author VALUES (12,'Hartpence','Bruce','');
126INSERT INTO author VALUES (13,'Leone','James','');
127INSERT INTO author VALUES (14,'Phelps','Andrew','');
128INSERT INTO author VALUES (15,'Henderson','Tona','');
129INSERT INTO author VALUES (17,'Webguy','Smerdley','');
130INSERT INTO author VALUES (18,'Jacobs','Steve','');
131INSERT INTO author VALUES (19,'Niemi','Rayno','');
132INSERT INTO author VALUES (20,'Kang','Jai','');
133INSERT INTO author VALUES (21,'Perez-Hardy','Sylvia','');
134INSERT INTO author VALUES (22,'Mason','Sharon','');
135INSERT INTO author VALUES (23,'Perry','Ron','');
136INSERT INTO author VALUES (24,'Whittington','Keith','');
137INSERT INTO author VALUES (25,'Bierre','Kevin','');
138INSERT INTO author VALUES (26,'Holden','Ed','');
139INSERT INTO author VALUES (27,'Axelrod','Mike','');
140
141
142--
143-- Dumping data for table 'category'
144--
145
146INSERT INTO category VALUES (1,'Romance');
147INSERT INTO category VALUES (2,'Comics');
148INSERT INTO category VALUES (3,'Programming');
149INSERT INTO category VALUES (4,'Database');
150INSERT INTO category VALUES (5,'Networking');
151INSERT INTO category VALUES (6,'Library Science');
152INSERT INTO category VALUES (7,'Science');
153INSERT INTO category VALUES (8,'Geography');
154INSERT INTO category VALUES (9,'Sports');
155
156
157--
158-- Dumping data for table 'state'
159--
160
161INSERT INTO state VALUES ('AK','ALASKA');
162INSERT INTO state VALUES ('AL','ALABAMA');
163INSERT INTO state VALUES ('AR','ARKANSAS');
164INSERT INTO state VALUES ('AS','AMERICAN SAMOA');
165INSERT INTO state VALUES ('AZ','ARIZONA');
166INSERT INTO state VALUES ('CA','CALIFORNIA');
167INSERT INTO state VALUES ('CO','COLORADO');
168INSERT INTO state VALUES ('CT','CONNECTICUT');
169INSERT INTO state VALUES ('DC','DISTRICT OF COLUMBIA');
170INSERT INTO state VALUES ('DE','DELAWARE');
171INSERT INTO state VALUES ('FL','FLORIDA');
172INSERT INTO state VALUES ('FM','FEDERATED STATES OF MICRONESIA');
173INSERT INTO state VALUES ('GA','GEORGIA');
174INSERT INTO state VALUES ('GU','GUAM');
175INSERT INTO state VALUES ('HI','HAWAII');
176INSERT INTO state VALUES ('IA','IOWA');
177INSERT INTO state VALUES ('ID','IDAHO');
178INSERT INTO state VALUES ('IL','ILLINOIS');
179INSERT INTO state VALUES ('IN','INDIANA');
180INSERT INTO state VALUES ('KS','KANSAS');
181INSERT INTO state VALUES ('KY','KENTUCKY');
182INSERT INTO state VALUES ('LA','LOUISIANA');
183INSERT INTO state VALUES ('MA','MASSACHUSETTS');
184INSERT INTO state VALUES ('MD','MARYLAND');
185INSERT INTO state VALUES ('ME','MAINE');
186INSERT INTO state VALUES ('MH','MARSHALL ISLANDS');
187INSERT INTO state VALUES ('MI','MICHIGAN');
188INSERT INTO state VALUES ('MN','MINNESOTA');
189INSERT INTO state VALUES ('MO','MISSOURI');
190INSERT INTO state VALUES ('MP','NORTHERN MARIANA ISLANDS');
191INSERT INTO state VALUES ('MS','MISSISSIPPI');
192INSERT INTO state VALUES ('MT','MONTANA');
193INSERT INTO state VALUES ('NC','NORTH CAROLINA');
194INSERT INTO state VALUES ('ND','NORTH DAKOTA');
195INSERT INTO state VALUES ('NE','NEBRASKA');
196INSERT INTO state VALUES ('NH','NEW HAMPSHIRE');
197INSERT INTO state VALUES ('NJ','NEW JERSEY');
198INSERT INTO state VALUES ('NM','NEW MEXICO');
199INSERT INTO state VALUES ('NV','NEVADA');
200INSERT INTO state VALUES ('NY','NEW YORK');
201INSERT INTO state VALUES ('OH','OHIO');
202INSERT INTO state VALUES ('OK','OKLAHOMA');
203INSERT INTO state VALUES ('OR','OREGON');
204INSERT INTO state VALUES ('PA','PENNSYLVANIA');
205INSERT INTO state VALUES ('PR','PUERTO RICO');
206INSERT INTO state VALUES ('PW','PALAU');
207INSERT INTO state VALUES ('RI','RHODE ISLAND');
208INSERT INTO state VALUES ('SC','SOUTH CAROLINA');
209INSERT INTO state VALUES ('SD','SOUTH DAKOTA');
210INSERT INTO state VALUES ('TN','TENNESSEE');
211INSERT INTO state VALUES ('TX','TEXAS');
212INSERT INTO state VALUES ('UT','UTAH');
213INSERT INTO state VALUES ('VA','VIRGINIA');
214INSERT INTO state VALUES ('VI','VIRGIN ISLANDS');
215INSERT INTO state VALUES ('VT','VERMONT');
216INSERT INTO state VALUES ('WA','WASHINGTON');
217INSERT INTO state VALUES ('WI','WISCONSIN');
218INSERT INTO state VALUES ('WV','WEST VIRGINIA');
219INSERT INTO state VALUES ('WY','WYOMING');
220
221
222--
223-- Dumping data for table 'book condition'
224--
225
226INSERT INTO bookcondition VALUES (1,'Bad','Not much is left of the book. Parts are not legible, cover may be missing.');
227INSERT INTO bookcondition VALUES (2,'Poor','Pages may be missing. Many pages may be marked.');
228INSERT INTO bookcondition VALUES (3,'Average','Less than 3 pages missing. Small markings. Cover intact.');
229INSERT INTO bookcondition VALUES (4,'Good','No pages missing, may be marked on less than 5 pages, not obscuring text or diagrams. Cover is in good condition');
230INSERT INTO bookcondition VALUES (5,'Excellent','Like new.');
231
232
233--
234-- Dumping data for table 'conditionevaluator'
235--
236
237INSERT INTO conditionevaluator VALUES ('bgq','Brendle Gottschalk Quakfloat');
238INSERT INTO conditionevaluator VALUES ('bwq','Brendle Whitehouse Quakfloat');
239INSERT INTO conditionevaluator VALUES ('bxz','Brendle Xavier Zorfwaite');
240INSERT INTO conditionevaluator VALUES ('efy','Everest Frandice Yerfwundle');
241INSERT INTO conditionevaluator VALUES ('evr','Everest Vorble Rufflehouse');
242INSERT INTO conditionevaluator VALUES ('ews','Everest Whitehouse Xavier');
243INSERT INTO conditionevaluator VALUES ('ggy','Gertrude Gottschalk Yerfwundle');
244INSERT INTO conditionevaluator VALUES ('gos','Gertrude Orlando Sweepfuddle');
245INSERT INTO conditionevaluator VALUES ('jfs','Jamie Frandice Sweepfuddle');
246INSERT INTO conditionevaluator VALUES ('jwg','Jamie Whitehouse Gruffwinder');
247INSERT INTO conditionevaluator VALUES ('pap','Paul Alfred Prefwindow');
248INSERT INTO conditionevaluator VALUES ('pop','Phyllis Orlando Prefwindow');
249INSERT INTO conditionevaluator VALUES ('pvp','Paul Vorble Prefwindow');
250INSERT INTO conditionevaluator VALUES ('rxg','Robert Xavier Gruffwinder');
251INSERT INTO conditionevaluator VALUES ('tag','Thomas Alfred Gruffwinder');
252INSERT INTO conditionevaluator VALUES ('tgr','Thomas Gottschalk Rufflehouse');
253INSERT INTO conditionevaluator VALUES ('wwq','William Whitehouse Quakfloat');
254INSERT INTO conditionevaluator VALUES ('xgz','Xavier Gottschalk Zorfwaite');
255INSERT INTO conditionevaluator VALUES ('xvx','Xavier Vorble Xavier');
256
257
258--
259-- Dumping data for table 'reviewer'
260--
261
262INSERT INTO reviewer VALUES (1,'Jacobs','Gadget Boy');
263INSERT INTO reviewer VALUES (2,'Troell','Dallas Underground');
264INSERT INTO reviewer VALUES (3,'Bills','The RIT Reporter');
265INSERT INTO reviewer VALUES (4,'Hill','Microsoft News');
266INSERT INTO reviewer VALUES (5,'Kurtz','MacIntosh News');
267INSERT INTO reviewer VALUES (6,'Leone',null);
268INSERT INTO reviewer VALUES (7,'Doubleday','Media Mania');
269INSERT INTO reviewer VALUES (8,'Wells','The RIT Reporter');
270INSERT INTO reviewer VALUES (9,'Worthington','The Annex');
271INSERT INTO reviewer VALUES (10,'Lawson','The Last Word');
272INSERT INTO reviewer VALUES (11,'Lasky',null);
273INSERT INTO reviewer VALUES (12,'Rozanski',null);
274INSERT INTO reviewer VALUES (13,'Whittington','JAVA Rocks');
275INSERT INTO reviewer VALUES (14,'Holden',null);
276INSERT INTO reviewer VALUES (15,'Stratton','Harvard Lampoon');
277INSERT INTO reviewer VALUES (16,'Johnson','NRA Weekly');
278INSERT INTO reviewer VALUES (17,'Mason','BMW Owners Quarterly');
279INSERT INTO reviewer VALUES (18,'Goodman','MacIntosh News');
280INSERT INTO reviewer VALUES (19,'Phelps','Detroit News');
281INSERT INTO reviewer VALUES (20,'Yacci','The Learning Channel');
282INSERT INTO reviewer VALUES (24,'Weeden','Scrye');
283INSERT INTO reviewer VALUES (25,'McVea','Programming Central');
284INSERT INTO reviewer VALUES (26,'Perez-Hardy','The Network Voice');
285INSERT INTO reviewer VALUES (27,'Heartthrob','Journal of Romance');
286INSERT INTO reviewer VALUES (28,'Bierre','JAVA Rocks');
287INSERT INTO reviewer VALUES (29,'Axelrod','JAVA Rocks');
288
289
290
291--
292-- Dumping data for table 'owner'
293--
294
295INSERT INTO owner VALUES (1,'Fribblestone','Gus','(716) 555-0975','GusBuster@arl.com','democrat');
296INSERT INTO owner VALUES (2,'Scott','Francis','(716) 555-4567','FranTheMan@arl.com','Habib');
297INSERT INTO owner VALUES (3,'Corplestein','Leslie','(716) 555-4567','LesTheLass@hopmail.com','Amit');
298INSERT INTO owner VALUES (4,'Corplestein','Ira','(716) 555-4567','IraBeForever@maybe.com','Peng');
299INSERT INTO owner VALUES (5,'Francis','Scott','(716) 555-0840','scotty@wherever.com','scotty');
300INSERT INTO owner VALUES (6,'Ling','Wei','(716) 555-4567','wxl0101@rit.edu','Cao');
301INSERT INTO owner VALUES (7,'Burblemonger','Mary','(716) 555-8865','GerbilLover@hatmail.com','mymy!');
302INSERT INTO owner VALUES (8,'Rabblewok','George','(716) 555-1989','ForRent@wherever.com','yourmine');
303INSERT INTO owner VALUES (9,'Tripplewander','Martha','(716) 555-2877','TakeMeFirst@quicksend.com','imfirst');
304INSERT INTO owner VALUES (10,'Lumberworker','George','(31) 555-5977','RachetMan@toolbox.net','timthetoolman');
305INSERT INTO owner VALUES (11,'Ferblemander','Frederick','(315) 555-6778','FerbieTheGreat@webSent.net','whoknows');
306INSERT INTO owner VALUES (12,'Ribblemaze','Ronda','(716) 555-2443','RibbleIsHere@webSent.net','idon');
307
308
309--
310-- Dumping data for table 'publisher'
311--
312
313INSERT INTO publisher VALUES (1,'CovertoCover Publishing','Rochester','NY');
314INSERT INTO publisher VALUES (2,'ReadMeFirst House of Publishing','New York','NY');
315INSERT INTO publisher VALUES (3,'TitlesRUs Book Company','Rochester','MN');
316INSERT INTO publisher VALUES (4,'ReadEmandWeep Romance Publishing','Chicago','IL');
317INSERT INTO publisher VALUES (5,'ScanALot Paperback Books','Chicago','IL');
318INSERT INTO publisher VALUES (6,'EZRead Masterpiece Comics','New York','NY');
319INSERT INTO publisher VALUES (7,'CumbersomeText Press','New York','NY');
320INSERT INTO publisher VALUES (8,'PrintingPress Magic','Rochester','NY');
321INSERT INTO publisher VALUES (9,'Guttenberg and Associates','Chicago','IL');
322INSERT INTO publisher VALUES (10,'ReadMeNext House of Publishing','New York','NY');
323INSERT INTO publisher VALUES (11,'ReadEmandSleep Publishing House','Hartford','CT');
324INSERT INTO publisher VALUES (12,'WebTime Publishing Incorporated','Boston','MA');
325INSERT INTO publisher VALUES (13,'The JAVA Press','San Francisco','CA');
326
327--
328-- Dumping data for table 'book'
329--
330
331INSERT INTO book VALUES ('1-111-11111-4','Women are From Venus ORACLE is from Beyond Pluto','New York Times Best Seller 27 weeks',1,'4',1);
332INSERT INTO book VALUES ('1-222-32443-7','Calculus for Phys Ed Majors','Carry our 200 lb text book: learn integrals and keep in Shape',7,'3',7);
333INSERT INTO book VALUES ('1-295-84547-1','My Love\'s Last Longing','Volume 1 of 4',1,'1',4);
334INSERT INTO book VALUES ('1-533-73363-8','From the Shores of Lake Erie to IT','One man\'s Journey to IT',8,'2',1);
335INSERT INTO book VALUES ('1-559-68777-1','My Love\'s Last Lingering Lost','Volume 2 of 4',1,'1',4);
336INSERT INTO book VALUES ('1-932-87447-6','The Science of Literature Searching','A Book Worth a Look is Worth a Good Look Up',6,'1',5);
337INSERT INTO book VALUES ('2-089-77869-5','Yes! Networking is for Bills Fans','How to Use a Spanning Tree to Exit Rich Stadium',9,'1',8);
338INSERT INTO book VALUES ('2-122-29058-5','How to Keep your Cellular Bill Down','How to carry 500 Miles of Fiber in Your Wallet',5,'2',2);
339INSERT INTO book VALUES ('2-221-11341-5','Tired of wired? Infrared instead!','500 Ways to pull out your hair while pulling out all your cable',5,'1',2);
340INSERT INTO book VALUES ('3-444-95595-4','ER, SOM, NF, DK/NF, SQL, JDBC, ODBC, and RELVAR','How U can avoid being trapped in Database acronyms',4,'1',3);
341INSERT INTO book VALUES ('3-445-43341-2','Master Wireless Through The Classic Comics','Infrared man triumphs over Cable Guy and CoAx NastyMan',2,'1',6);
342INSERT INTO book VALUES ('3-445-58668-5','How to Keep your Cable Bill Down','How to Avoid Tripping on 500 Miles of Fiber in your wallet',5,'1',10);
343INSERT INTO book VALUES ('4-344-22221-1','I Lasted my Love\'s Last Lingering Longing','Volume 3 of 4',1,'2',4);
344INSERT INTO book VALUES ('4-668-39283-8','From Deep in the Heart of Texas to IT','One man\'s Journey to IT',8,'1',1);
345INSERT INTO book VALUES ('5-538-55746-1','My Lost Love\'s Long Last Lingering','Volume 4 of 4',1,'1',4);
346INSERT INTO book VALUES ('6-449-68668-8','From Brockport to IT','Prof. Johnson\'s Journey to IT (about 25 min via 490)',8,'1',1);
347INSERT INTO book VALUES ('7-999-14432-2','Master HTML Through The Classic Comics','Using his Super Web thrower, Spiderman creates HTML docs',2,'2',6);
348INSERT INTO book VALUES ('8-330-69586-6','The Shortest Book in the World','A Guide to how Detroit will win the World Series in 2001',9,'1',3);
349INSERT INTO book VALUES ('9-333-44441-1','My Love\'s at Long Last Lost his Lingering','Volume 5 of 4',1,'1',4);
350INSERT INTO book VALUES ('9-337-55467-3','How to add Class to your Programming','How to write programs in VB instead of C',3,'3',10);
351INSERT INTO book VALUES ('9-400-55555-2','Master C++ Through The Classic Comics','GeekMan triumphs over C++ program infected with Kryptonite virus',2,'1',6);
352INSERT INTO book VALUES ('9-444-43356-3','A language without Pointers? Priceless.','For Everything Else, there\'s C++',3,'1',13);
353INSERT INTO book VALUES ('9-455-61223-3','JAVA: It\'s more than Just a Programming Language','Achieve enlightenment through the mystery of the Swing package',3,'1',7);
354
355--
356-- Dumping data for table 'bookauthor'
357--
358
359INSERT INTO bookauthor VALUES ('1-111-11111-4',9,'Y');
360INSERT INTO bookauthor VALUES ('1-222-32443-7',5,'N');
361INSERT INTO bookauthor VALUES ('1-222-32443-7',11,'N');
362INSERT INTO bookauthor VALUES ('1-222-32443-7',12,'Y');
363INSERT INTO bookauthor VALUES ('1-295-84547-1',7,'Y');
364INSERT INTO bookauthor VALUES ('1-533-73363-8',2,'Y');
365INSERT INTO bookauthor VALUES ('1-559-68777-1',7,'Y');
366INSERT INTO bookauthor VALUES ('1-932-87447-6',8,'Y');
367INSERT INTO bookauthor VALUES ('1-932-87447-6',15,'N');
368INSERT INTO bookauthor VALUES ('2-089-77869-5',6,'Y');
369INSERT INTO bookauthor VALUES ('2-089-77869-5',13,'N');
370INSERT INTO bookauthor VALUES ('2-089-77869-5',14,'N');
371INSERT INTO bookauthor VALUES ('2-122-29058-5',12,'Y');
372INSERT INTO bookauthor VALUES ('2-221-11341-5',12,'Y');
373INSERT INTO bookauthor VALUES ('3-444-95595-4',2,'Y');
374INSERT INTO bookauthor VALUES ('3-445-43341-2',12,'Y');
375INSERT INTO bookauthor VALUES ('3-445-58668-5',12,'Y');
376INSERT INTO bookauthor VALUES ('4-344-22221-1',7,'Y');
377INSERT INTO bookauthor VALUES ('4-668-39283-8',5,'Y');
378INSERT INTO bookauthor VALUES ('5-538-55746-1',7,'Y');
379INSERT INTO bookauthor VALUES ('6-449-68668-8',10,'Y');
380INSERT INTO bookauthor VALUES ('7-999-14432-2',1,'N');
381INSERT INTO bookauthor VALUES ('7-999-14432-2',17,'Y');
382INSERT INTO bookauthor VALUES ('8-330-69586-6',14,'Y');
383INSERT INTO bookauthor VALUES ('9-333-44441-1',7,'Y');
384INSERT INTO bookauthor VALUES ('9-337-55467-3',19,'N');
385INSERT INTO bookauthor VALUES ('9-337-55467-3',20,'Y');
386INSERT INTO bookauthor VALUES ('9-400-55555-2',1,'N');
387INSERT INTO bookauthor VALUES ('9-400-55555-2',17,'Y');
388INSERT INTO bookauthor VALUES ('9-444-43356-3',25,'Y');
389INSERT INTO bookauthor VALUES ('9-444-43356-3',27,'N');
390INSERT INTO bookauthor VALUES ('9-455-61223-3',4,'Y');
391
392
393--
394-- Dumping data for table 'bookreview'
395--
396
397INSERT INTO bookreview VALUES ('1-111-11111-4',19,10,'Hold on to your hats, gang! If you think a cookbook or the yellow pages is exciting reading, you gotta read Professor Spada\'s remarkable treatise on enriching you personal relationships through your knowledge of ORACLE 8.1.6. In an easy-to-read fashion, s');
398INSERT INTO bookreview VALUES ('1-295-84547-1',27,10,'This is one of the most outstanding books ever written. Five thumbs up. Five stars. A must-read for everyone.');
399INSERT INTO bookreview VALUES ('1-533-73363-8',20,4,'A rather boring autobiography of a northern Ohio native who migrates to Rochester New York where he becomes a professor of Information Technology at RIT. Other than the chapters devoted to the Cleveland Indians (chapters 1, 2, 3, 6, 10, 11, 12, 13), The C');
400INSERT INTO bookreview VALUES ('1-559-68777-1',2,8,'A wonderful romance novel about Matt, a successful editor for the New York Times, who resigns and retreats to a Dude Ranch in New Mexico to find himself.  Matt meets Margaret, a person with cowgirl charm in touch with her masculine self. Matt falls in lov');
401INSERT INTO bookreview VALUES ('1-559-68777-1',19,9,'A wonderful romance novel about Margaret, a successful editor for the New York Times, who resigns and retreats to a Dude Ranch in New Mexico to find herself.  Margaret meets Matt, a person with tough cowboy swagger in touch with his feminine self. Margare');
402INSERT INTO bookreview VALUES ('2-089-77869-5',5,5,'Definitely don\'t buy this book if you are a Giants fan.  Two Giants fans tried this technique at the Giants game several weeks ago and they aren\'t back yet.');
403INSERT INTO bookreview VALUES ('2-089-77869-5',13,8,'For any networking buff/Bills fan, Dr. Lutz\' treatise on the use of spanning trees to exit a Buffalo Bills game is a must. It is difficult to slog through in spots, but he shows you that by applying his minimalization technique you can get back to Rochest');
404INSERT INTO bookreview VALUES ('2-089-77869-5',15,6,'Don\'t buy this book unless your are  Bills fan.  Fans of any other team will find their departure time from a Bills game actually triples when the technique is applied. In fact, it probably accounts for why Dr. Lutz (and any other Bills fan who applies it');
405INSERT INTO bookreview VALUES ('2-122-29058-5',6,7,'Professor Hartpence shows you how to carry 500 miles of fiber in your wallet.  Warning to the unwary: don\'t buy this book unless you have deep pockets.');
406INSERT INTO bookreview VALUES ('2-122-29058-5',13,8,'Watch out Jim Carey .. this non-cable guy may leave you out of work. In his book, Professor Hartpence combines his cellular and networking skills with his experience in both the military and the commercial world and the practice of Zen to show you how to');
407INSERT INTO bookreview VALUES ('3-444-95595-4',3,4,'U lose if you ever bother to read this book.');
408INSERT INTO bookreview VALUES ('3-445-58668-5',6,7,'This book is a follow-up to Professor Hartpence\'s book on how to carry 500 miles of fiber in your wallet.');
409INSERT INTO bookreview VALUES ('4-344-22221-1',24,7,'A wonderful romance novel about Nelson, a successful editor for the New York Times, who resigns and retreats to a Dude Ranch in New Mexico to find himself.  Nelson meets Laura, a person with cowgirl charm in touch with her masculine self. Nelson falls in');
410INSERT INTO bookreview VALUES ('4-668-39283-8',6,6,'A sometimes boring autobiography of a Texan transplanted to Rochester New York where he becomes a professor of Information Technology at RIT. Other than the chapters devoted to the Dallas Cowboys (chapters 1, 2, 3, 6, 10, 11, 12, 13), The Presidential ele');
411INSERT INTO bookreview VALUES ('5-538-55746-1',15,9,'A wonderful romance novel about Laura, a successful editor for the New York Times, who resigns and retreats to a Dude Ranch in New Mexico to find herself.  Laura meets Nelson, a person with tough cowboy swagger in touch with his feminine self. Laura falls');
412INSERT INTO bookreview VALUES ('6-449-68668-8',20,7,'The funny, often racy, autobiography of Daryl Johnson and his escapades to and from RIT. The book is largely about the excitement of commuting from the west side to RIT every day and how much fun it can be. A great book for those who live on the west side');
413INSERT INTO bookreview VALUES ('6-449-68668-8',26,10,'An absolutely outstanding autobiography of a Saint John Fisher Graduate and how he has adapted to his 20 minute ride (mostly on 490) to RIT every morning and his 20 ride (mostly on 490) home from RIT every night. The author uses thirteen chapters to vibra');
414INSERT INTO bookreview VALUES ('8-330-69586-6',5,10,'Geez .. no pages, no paragraphs, no words .. not even an illustration. But he did dedicate the book to Tony Clark. Says something for the fervor of this Detroit Tigers fan.');
415INSERT INTO bookreview VALUES ('8-330-69586-6',15,10,'Very accurate analysis of a problem that is not NP complete.');
416INSERT INTO bookreview VALUES ('9-333-44441-1',24,7,'Throwing the usual themes and twists of a romance novel to the winds, the author tells the store of Laura, a successful Dude Ranch owner in New Mexico, who resigns and moves to New York to seek her fortune as an editor for the New York Times. Laura meets');
417INSERT INTO bookreview VALUES ('9-337-55467-3',25,9,'These authors know their way around a coding pad, let me tell you! In clear, bell-shaped tones, with succinct wording and pinpoint accuracy, they nail this subject matter to the wall. Do you like inheritance? How about information hiding? Maybe you like e');
418INSERT INTO bookreview VALUES ('9-455-61223-3',13,9,'Professor Sonstein shows how oneness with the spiritual universe can be achieved by bringing the soul into rhytmn with the JAVA runtime machine. He shows that through various forms of self denial, such as writing code without pointers and heavy weight com');
419
420
421--
422-- Dumping data for table 'ownersbook'
423--
424
425INSERT INTO ownersbook VALUES (2,'2-089-77869-5',4,'gos','',40.00,'b');
426INSERT INTO ownersbook VALUES (3,'1-295-84547-1',4,'gos','',50.00,'s');
427INSERT INTO ownersbook VALUES (3,'1-533-73363-8',3,'wwq','',null,'b');
428INSERT INTO ownersbook VALUES (3,'4-668-39283-8',3,'jwg','',null,'s');
429INSERT INTO ownersbook VALUES (4,'2-089-77869-5',4,'pop','',75.00,'s');
430INSERT INTO ownersbook VALUES (4,'2-122-29058-5',5,'pop','',65.00,'s');
431INSERT INTO ownersbook VALUES (4,'3-444-95595-4',2,'pvp','',null,'s');
432INSERT INTO ownersbook VALUES (5,'2-122-29058-5',4,'pvp','',25.00,'s');
433INSERT INTO ownersbook VALUES (5,'3-444-95595-4',3,'pvp','',50.00,'s');
434INSERT INTO ownersbook VALUES (6,'1-932-87447-6',2,'rxg','',60.00,'b');
435INSERT INTO ownersbook VALUES (6,'4-668-39283-8',3,'rxg','',null,'s');
436INSERT INTO ownersbook VALUES (6,'9-333-44441-1',4,'bwq','',100.00,'b');
437INSERT INTO ownersbook VALUES (7,'1-559-68777-1',4,'efy','',80.00,'b');
438INSERT INTO ownersbook VALUES (8,'2-122-29058-5',2,'ggy','',65.00,'s');
439INSERT INTO ownersbook VALUES (9,'3-445-58668-5',1,'jwg','',45.00,'b');
440INSERT INTO ownersbook VALUES (9,'4-344-22221-1',3,'jwg','',null,'s');
441INSERT INTO ownersbook VALUES (9,'5-538-55746-1',4,'jwg','',25.00,'s');
442INSERT INTO ownersbook VALUES (9,'8-330-69586-6',2,'bgq','',35.00,'s');
443INSERT INTO ownersbook VALUES (10,'1-533-73363-8',3,'bgq','',0.00,'s');