Database

book (isbn, title, authorID, genre, pubYear, publisher, rrPrice) author (aID, fName, surname) bookShop (shopNo, shopName, street, city, county) order (orderNo, SNo, oDate, salesRep) orderDetails (ONo, bookISBN, quantity) Information is held on books, the authors of those books and the books ordered by bookshops through sales representatives in five tables. The book table holds details orn each book: the unique isbn, the title (title), the ID of the author (authorID), the genre (genre) of the book (e.g. fiction, science), the year the book was published (pubYear), the publisher name (publisher) and the recommended retail price (rrPrice) in euros. The author table holds the author's first name (fName) and surname (surname), and the author ID (aID). Note that one author can write many books but that each book has only a single author The bookShop table holds details on bookshops: a unique shop number (shopNo), the bookshop name (shopName) and bookshop address (street, city, county). The order table holds some of the details on the orders with a unique order number for each order (orderNo), the unique ID of the shop who place the order (sNo), the date the order was placed (oDate) and the name of the sales representative who takes the order (salesRep). Note that one shop can place many orders. The orderDetails table holds details, per order (oNo), on the actual books (bookISBN) ordered and the quantity required of each book per order (quantity). Note that an order can contain many books and that one book can be included in multiple different orders