How to run the Project:
- Clone this repo using
git clone https://github.com/RohithgowdaM/DBMS-EL.git
- Install Eclipse J2EE or any other IDE of your choice.
- Use MySQL workbench to connect to the database.
- First create the MySql database on MySQL workbench using the sql file in the repo.
- And then build and run the project from the IDE.
- Install MongoDBCompass for connecting to NoSQL database.
- In connect.java file enter your mysql connection string and connect to database.
- DBconnect.java connects the frontend into NoSQL database, enter your credentials to connect to your backend.
- Run Main.java
Login Information
id :1
password: admin
note: The login information can be changed while setting up MySQL or via UI later
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.
o MonogoDBCompass.
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
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
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).
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
DFD LEVEL-0
Fig 2: DFD level-0
DFD LEVEL-1
Fig 2: DFD level 1
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
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.
#dbms #nosql #mongodb #sql #mysql-workbench #java