insert into Publisher 
values ('P117', 'Virgil-Bingsley', 'Canberra', '31415926');
insert into Publisher
values ('P232', 'Fred-Jones', 'Ratchet', '342934');
insert into Publisher
values ('P314', 'Jim-Bob', 'Spoontown', '707');
insert into Publisher
values ('P612', 'Bing and Co', 'Plinth', '23981');
insert into Publisher
values ('P120', 'GoonPub Inc', 'Plinth', '12932');
insert into Publisher
values ('P8AZ', 'Tree-Winden', 'Hilly Knob', '(A3)-9238 PlQ');
insert into Publisher
values ('P1', 'Addison-Wesley', 'Spoontown', '1254');

insert into Author
values ('A921', 'Asimov', 'I', 'Spoontown', '0921', '12-JUN-1923');
insert into Author
values ('A17', 'Jordan', 'R', 'Plinth', '1281', '17-SEP-1948');
insert into Author
values ('A16', 'Frink', 'P', 'Springfield', 'K-182', '15-MAY-1962');
insert into Author
values ('A314', 'Spindol', 'QR', 'Ratchet', 'QRT-192', '3-AUG-2007');
insert into Author
values ('A1', 'Vertex', 'F', 'Vectoring WA', 'VT-173', '12-DEC-1982');
insert into Author
values ('A707', 'Howe', 'A', 'Canberra ACT', '6296 7261', '01-JAN-0001');
insert into Author
values ('A666', 'Peterson', 'V', 'Canberra ACT', '6666 6666', '09-APR-1056');
insert into Author
values ('A252', 'Calculus', 'P', 'Europe somewhere', '1', '27-OCT-1927');

insert into Book
values ('1-231-32773-2', 'Structures and Theories of Mathematical Animals (mostly Fish)', 2, 'P314', '12-APR-2002', 16, 18.56, 7);
insert into Book
values ('0-564-62365-8', 'You and Mechanical People Replicating Devices', 17, 'P117', '2-NOV-1728', 12, 15.95, 102);
insert into Book
values ('7-232-23213-4', 'The History of Spoontown (We all like spoons!)', 3, 'P8AZ', '17-OCT-1978', 17, 25.95, 76);
insert into Book
Values ('0-231-43423-3', 'Robots of Dawn, The', 5, 'P1', '3-JUL-1954', 12, 18.56, 18);
insert into Book
values ('1-236-87456-5', 'Foundation', 23, 'P1', '6-AUG-1940', 8, 16.29, 57);
insert into Book
values ('0-666-34224-6', 'Linear Algebra Sux!', 4, 'P120', '12-JUN-2001', 57.95, 84.95, 75);
insert into Book
values ('5-453-65233-4', 'Calculus is Good to eat!', 7, 'P8AZ', '15-MAR-1998', 86.97, 112.95, 109);
insert into Book
values ('7-234-65412-7', 'How to learn stuff', 3, 'P117', '30-SEP-1002', 120.95, 181.92, 1001);
insert into Book
values ('0-234-85845-6', 'Relational Databases, The Vicki way',7,'P1',  '23-DEC-1999', 25, 32.95, 1);


insert into Authorship
Values ('1-231-32773-2', 'A707');
insert into Authorship
values ('0-564-62365-8', 'A921');
insert into Authorship
values ('7-232-23213-4', 'A1');
insert into Authorship
values ('0-231-43423-3', 'A1');
insert into Authorship
values ('1-236-87456-5', 'A1');
insert into Authorship
values ('0-666-34224-6', 'A252');
insert into Authorship
values ('5-453-65233-4', 'A252');
insert into Authorship
values ('7-234-65412-7', 'A314');
insert into Authorship
values ('0-234-85845-6', 'A666');

insert into Textbook
values ('COMP2400', '0-234-85845-6', '15-JUL-2002', 350, 27);
insert into Textbook
values ('MATH1014', '0-666-34224-6', '19-JUL-2001', 165, 170);
insert into Textbook
values ('MATH1275', '5-453-65233-4', '17-DEC-1985', 12, 98);
insert into Textbook
values ('COMP1100', '7-234-65412-7', '11-JAN-2006', 213,345);
insert into Textbook
values ('MATH1013', '1-231-32773-2', '30-NOV-2001', 770, 92);