connect shop;

insert into BookShop (itemNo, itemType, title, author, price)
values ("BOOK1", "BOOK", "Catcher in the Type", "J.D. Salinger", 15.00),
("BOOK2", "BOOK", "Illusions", "Richard Bach", 15.00),
("BOOK3", "BOOK", "The Fountainhead", "Ayn Rand", 15.00),
("BOOK4", "BOOK", "Notes to MySelf", "Hugh Prather", 15.00);

