Books Tables

<PRE>

drop table books;

create table books (genre varchar2(6), name varchar2(40), afn varchar2(20), aln varchar2(20),

price number(6,2), cost number (6,2), quantity number, type varchar2(10),

pages number(4), pub_date varchar2(20), publisher varchar2(25), isbn varchar2(20),

character varchar2(40), description varchar2(250), constraint isbn_pk primary key (isbn));

insert into books values ('mys','Murder Down Under','Arthur William','Upfield',

11.00, 4.00, 121,'Paperback',304,'September 1998','Scribner','0684850591',

'Napoleon Bonaparte','The detective is on holiday in western Australia but

inevitably winds up with a working vacation. Farmer George Loftus has disappeared.');

insert into books values ('mys','The Franchise Affair','Josephine','Tey',

11.00,3.75,94,'Paperback',288,'August 1998','Scribner','0684842564','Robert Blair',

'Marion Sharpe and her mother are accused of brutally kidnapping a demure young woman

named Betty Kane.');

insert into books values ('mys','Whose Body?','Dorothy','Sayers',

5.99,4.79,24,'Paperback',322,'August 1995','Harper','0061043575','Lord Peter Wimsey',

'Wimsey himself views the stark naked body lying in the tub. The brilliant detective

untangles the ghastly murder in spite of incorrect assumptions by the police.');

insert into books values ('mys','Blood Shot','Sara','Paretsky',

5.59,1.40,189,'Paperback',279,'June 1989','Dell Publishing Company','0440204208',

'V I Warshawsky','V I returns in her fifth case as a missing person assignment turns

into a murder investigation. She investigates big business corruption and chemical waste.');

insert into books values ('mys','Complete Sherlock Holmes','Sir Arthur Conan','Doyle',

27.95,19.57,47,'Hardcover',1012,'May 1960','Doubleday','0385006896','Sherlock Holmes',

'This volume contains all 4 full-length novels and all 56 short stories featuring

Sherlock Holmes.');

insert into books values ('mys','Jim Chee Mysteries','Tony','Hillerman',

24.00,16.80,72,'Hardcover',743,'October 1990','Harpercollins','0060164786','Jim Chee',

'Three books featuring Native American police in the Southwest.');

insert into books values ('mys','Bones and Silence','Reginald','Hill',

5.99,3.79,123,'Paperback',443,'August 1996','Dell Publishing Company','0440209358',

'Peter Pascoe','Very funny british humor. Yorkshire detective inspectors Andrew Dalziel

and Peter Pascoe investigate anonymous notes from someone threatening suicide.');

insert into books values ('mys','Pocket Full of Rye','Agatha','Christie',

5.99,4.79,324,'Paperback',185,'March 1996','Berkley Pub Group','0425130282','Jane Marple',

'The wealthy Rex Fortescue falls dead at a normal tea. The only clue is rye in his

pocket. Miss Marple uses an old nursery rhyme to help solve the murder.');

insert into books values ('mys','A Is for Alibi','Sue','Grafton',

6.99,2.59,340,'Paperback',214,'July 1987','Bantam Books','0553279912','Kinsey Millhone',

'The jury believed that Laurence Fife was killed by his wife Nikki. Now she is out on

parole and Kinsey Milhone tries to find who really killed her husband.');

insert into books values ('scifi','Heavens Reach','David','Brin',

24.95,17.47,248,'Hardcover',512,'July 1998','Bantam Books','0553101749','Lark',

'It chronicles the adventures of those from the planet Jijo who have left or been

taken from their homes only to be swept into the intrigues of galactic politics.');

insert into books values ('scifi','Dreaming Metal','Melissa','Scott',

14.95,11.96,199,'Paperback',320,'September 1998','St Martins Press','0312866585',

'Celeste','Melissa Scott tackles the concept of artificial intelligence and how

it will impact society.');

insert into books values ('scifi','Factoring Humanity','Robert','Sawyer',

5.99,4.79,227,'Paperback',352,'May 1999','Tor Books','0812571290','Heather Kyle',

'The plot revolves around a professor struggling to decipher extraterrestrial messages

and her husband who is on the brink of a big computer science breakthrough.');

insert into books values ('scifi','Einsteins Bridge','John','Cramer',

3.99,3.19,84,'Paperback',310,'May 1998','Eos','0380788314','George Hanson',

'The story begins in an alternate universe where the Superconducting Super Collider

project did not collapse in the 1990s.');

insert into books values ('scifi','Imago','Octavia','Butler',

5.99,4.79,143,'Paperback',220,'April 1997','Warner Books','0446603635','Jodahs',

'This conclusion to the Xenogenesis series focuses on the child of a union between

humans and alien Oankali and the sexless ooloi.');

</PRE>