inventory-system

This is an inventory management software built in Java using MySQL database that can be used at any Point of Sale of a small to mid-sized store.

INTRODUCTION: The main aim of the project is the management of the database of the pharmaceutical shop. This project is insight into the design and implementation of a Pharmacy Management System. This is done by creating a database of the available medicines in the shop. The primary aim of pharmacy management system is to improve accuracy and enhance safety and efficiency in the pharmaceutical store. The aim of this project is to develop software for the effective management of a pharmaceutical store. We have developed this software for ensuring effective policing by providing statistics of the drugs in stock. Description on the topic: This program can be used in any pharmaceutical shops having a database to maintain. The software used can generate reports, as per the user’s requirements. The software can print invoices, bills, receipts etc. It can also maintain the record of supplies sent in by the supplier. Here, the admin who are handling the organization will be responsible to manage the record of the employee. Each employee will be given with a separate username and password. Problem Definition: The aim of the project is to create an effective software to help the pharmacist to maintain the records of the medicines, handle user details, generate invoice, check and renew validity and provide a scope of communication between users by using inbuilt messaging system. Pharmacy management system deals with the maintenance of drugs and consumables in the pharmacy unit. This pharmacy management system is user friendly. Objectives -> Primary objective •To gain practical experience by modeling a software based on real world problem. •To understand how to work on Front-end (Java) and Back-end (MySQL) by using server(wamp). -> Secondary objective •To develop an application that deals with the day to day requirement of any pharmacy. •To develop the easy management of the medicines (drugs). •To handle the inventory details like sales details, purchase details and stock expiry and quantity. •To provide competitive advantage to the pharmacy. •To provide details information about the stock on details necessary and help locate it in shop easily. •To make the stock manageable and simplify the use of inventory in the pharmacy. Hardware and software tools: The system services and goals are established by consultation with system user. They are then defined in details and serve as a system specification. System requirement are those on which the system runs. ⚙️ Hardware Requirements: o Computer with either Intel Pentium processor or AMD processor. o 1GB+ DDR RAM o 40GB hard disk drive 💻 Software Requirements: o Windows/ MacOS/ Linux operating system. o JRE and JDK. o MySQL server (WAMP or XAMPP or any) Chapter 2 - DESIGN Database Design is a collection of processes that facilitate the designing, development, implementation and maintenance of enterprise data management systems. It helps produce database systems: o That meet the requirements of the users o Have high performance. Architecture Description The design of a DBMS depends on its architecture. It can be centralized or decentralized or hierarchical. The architecture of a DBMS can be seen as either single tier or multi-tier. ER Diagram image.png Fig 1: ER Diagram An entity–relationship model describes interrelated things of interest in a specific domain of knowledge (Refer Fig 1). It is composed of entity types and specifies relationships that can exist between instances of those entity types. Relational Schema Diagram image_1.png Fig 2: Relational Schema Relational schema is a collection of meta-data. Database schema describes the structure and constraints of data representing in a particular domain (Refer Fig 2). Chapter 3 - IMPLEMENTATION Description on Implementation The goal of this application is to manage the medicines and various function of the pharmacy. List of modules: o Login page o Home page o Company o Purchase o Drugs o Sales o User/Settings o Messaging Chapter 4 - Result and Discussion By using MySQL commands and its database this website Pharmacy management tends to store all the data received from the users including drugs sales details and the profit made by the owners are all in this data base. This website allows the user to generate invoices for sales, check expiry and quantity remaining of the drugs. It also provides user with options to renew validity and add more drugs into the store and update the database accordingly. By using xampp server these database commands are easily initiated into the database and the ER diagram with relational schema diagrams helps us to make the structure of the database faster and it was easier to make them understand the needs of the website. Login Information id :1 password: admin CONCLUSIONS AND FUTURE SCOPE o Detailed information gathering has to be done. Without that the purpose for using the software won’t be satisfied properly. o However, it can give good profits in the long run. o Implementing the software requires change in the business practices. o Efficient organization of all knowledge is the analysis company and easy analysis access and retrieval of information is possible. o In this project we can also include BAR CODE facility using the bar code reader, which will detect the expiry date and the other information about the related medicines. o Company using this software will always be able to plan in future and always be aware of their financial position in the market. o It leads to ease in functioning of business processes. o The project can be made more robust by including biometric verification. o There is also a scope to expand by implementing newer technologies like cloud etcetera.

Cafe management system is used for maintaining the details, Sales, billing and maintains an inventory for the Cafe. This project developed using Java, MVC and database used.

This project helps us to access and manage the information easily. And also helps to verify the stock currently available with them and to update the stock when necessary. This project reduce the time to search the product from the current available stock.The role of an inventory system is to track your products and supplies. Inventory management is the process of controlling of the ordering, storage and use of components that a company uses in the production of the products it sells.

An inventory management REST API built with Spring Boot, designed to handle product stock, supplier relationships, order processing, and manual inventory movements. This project is intended as a foundational backend system for managing inventory in small to mid-sized businesses.

A Spring Boot-based inventory management system using Spring AI 1.0.0-M7 and Ollama for conversational interfaces. It follows an API-first design with OpenAPI to auto-generate client/server code and implements hexagonal architecture for modularity and scalability.