I am creating a library management system for my first project. The primary objective is to have a management system for users who are going inside and out the library. What my plan is:
- The users of the library have QR code that I generated myself and if the QR code is scan to the system, it will trigger the data on the database.
- If the user exist on the database, the system will redirect them to the purpose of visit page where they can submit their selected purpose of visit using checkboxes that will go to the database.
- The management system will consist many databases like
-Time-in and Time-out
-Library services/Purpose of visit(like wi-fi use, library space, etc.)
-User info and demographic - Lastly, there will be a generated report per month that is based from the databases(like how many male/female, which school, categories (like high school, senior citizens, PWD, etc.)), and also the purpose of visits).
I currently finished the QR code generator part and I am still doing the layout and flowcharts for the management system before I will start to create program for the management system.
Sorry if my sentences are poorly constructed as I am not fluent in English. I am not sure what database approach to use, if SQL or NoSQL. I am open for any suggestions. Thanks in advance!
New contributor
Bernie Norman is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.