Book-Store | database system to support the operations

Book-Store is a Java library. Book-Store has no bugs, it has no vulnerabilities and it has low support. However Book-Store build file is not available. You can download it from GitHub.

To add a new book, the user enters the properties of the new book along with a threshold (the minimum quantity in stock to be maintained for that book). For updating an existing book, the user first searches for the book then he does the required update. For a given book, the user can update the quantity in stock when a copy or more of the book is sold. The user cannot update the quantity of a book if this update will cause the quantity of a book in stock to be negative. (hint: trigger before update). An order with constant quantity is placed only when the quantity of a book drops from above a given threshold (the minimum quantity in stock) to below the given threshold (hint: trigger after update in books table). The user can confirm an order when receiving the ordered quantity from the book’s publisher; the quantity of the book in store automatically increases with the quantity specified in the order. Assume that deleting the order means that the order is received from publisher. (hint: trigger before deletion from orders table). The user can search for a book by ISBN, and title. The user can search for books of a specific Category, author or publisher. The Login can be done by a customer or a manager which will differ the UI where the manager has more functionalities than the customer. • View the items in the cart. • View the individual and total prices of the books in the cart. • Remove items from the cart. • The customer is then required to provide a credit card number and its expiry date, This transaction is completed successfully if the credit card information is appropriate. • The book’s quantities in the store are updated according to this transaction. • Doing this will remove all the items in the current cart. a. The total sales for books in the previous month. b. The top 5 customers who purchase the most purchase amount in descending order for the last three months. c. The top 10 selling books for the last three months.