Book Shop Management System

Book Shop Management System is the computerized application to automate all kinds of activity in Book Shop.

1. Software Development Project 2 Presented by Rifat Mia Dept. of CSE , JKKNIU Supervised by Kazi Mahmudul Hassan Assistant Professor Dept. of CSE, JKKNIU

2. Project Title ‘Book Shop Management System’

3. Roadmap Introduction Languages & Tools Features Overview of Project Physical description Database Advantages Limitations Future Enhancement Conclusion

4. Introduction Book Shop Management System is the computerize application to automate all kinds of activity in book shop. The main aim of this software is to manage the books in the book store. This software is very helpful for maintain the records of sales and this system keeps all the record of books, receipts, sales, inventory and stocks.

5. Objectives To search records of a book efficiently. Processing a large amount of data effectively and efficiently. To provide better service. It keeps database of book details, price, sales record and Customer record.

6. Languages & Tools Java SQL Netbeans IDE 8.2 Xampp MySQL

7. Features Login Facility [Starting the software] Logout Facility Managing Books Managing Category Search book by Name, Writer and Category. Selling Books

8. Features Search Sale History Summary of selling Total Selling Amount Total Paid Amount Total Due Amount Managing Due records Managing Customer Information

9. Overview Book Shop Management System Books Search Add New Book Update Book Remove Book Writer Category Search View Category Add Category Remove Category Sell Sales Record Customer

10. Project Features Description

11. Login Window Enter Username and Password. If wrong value is entered, it shows error message. Otherwise, it runs the Main Window.

12. Main Window After Successful Login, The Main Window will be shown.

13. Managing Books First work of user is to add, update or remove books.

14. Managing Books In this window, user can add new book.

15. Managing Books In this window, user can Update a book.

16. Managing Books In this window, user can remove a book.

17. In this window, user can search books by Book name.

18. In this window, user can search books by Writer name.

19. In this window, user can search books by Category.

20. Managing Category In this window, user can Add a new Category.

21. Managing Category In this window, user can Remove an existing Category.

22. Sell Books This window is used to sell books.

23. Sell Books Here have to search the name of the book first. When selecting book for selling, its corresponding data ie , writer, category, available stock to sell and selling price has been displayed. Next have to enter the customer name, quantity and discount. The ADD button add the book to the selling book list. Total Amount show the total cost of the books. Next have to enter how much money to pay. ‘Due’ will show how much is due. ‘Save & View’ will save database to commit and view receipts. ‘Print’ will print the receipts.

24. Managing Due Records In this window, user can see and manage due customers record.

25. Managing Sales Record In this window, user can see and manage sales record.

26. Managing Customers Record In this window, user can see and manage customers record.

27. Advantages Less time to search for the specified books. Saving in stationary. Proper and clean work. Better search ability and availability.

28. Limitations Since this software is built on the Java programming language, it will not run without jdk . Username and password cannot be changed or updated at login. The return book has no option in this project, in which case customer records and sales records have to be updated. Online facility is not available.

29. Future Enhancements In future, our aim to develop it for maintain a super book market in actual field and extends the system with Credit Card and Laser Product Detection System.

30. Conclusion This software is successfully done to maintain a Book shop’s transaction. The project is completed that follow the Incremental Model.

31. THE END