Pharmacy Management System Project Report.
Pharmacy Management System Project Report.
Pharmacy Management System Project Report.
INTERNSHIP REPORT
ON
PHARMACY MANAGEMENT SYSTEM
PROJECT
BY
KAMAL ACHARYA
(Tribhuvan University)
Date: 2020/03/10
1
1. INTRODUCTION
Master Module
Transaction Module
Order Module
Report Module
This Master module has of Buyer form, suppler form, product information’s form;
purchase form, stock form, sales form, sales return form, and payment detail form are also
maintained within this. Purchase Form deal with purchase order of Medicine based on the
stock. The level is increased when some purchase can be done and it can be monitored
frequently by the stock.
Stock Form deals with the details of the stock maintained in the stores. The
system provide some message to indicate if the stock reach its level and tit is easy tom
increase level of the stock. The system can increase its stock level when some purchase
and sales return is done and its stock reduces level some sales done.
Sales Details deals with sales order of medicine based on the stock, the level is
decreased when some sales can be done and it can be monitored frequently by the stock
level. The sales return details system can increase the stock level when some sales return.
Transaction Module maintains Buyer and Order process. Buyer process deals with
the information about the buyer are differentiated us regular Buyer or new Buyer. The
2
regular buyer is provided by special offer discount. This helps to motivate some of new
buyer to become a regular buyer.
Order process deals with the order which is given by buyer. Every order is
separately stored.
Purchaser Report
Stock Report
Sales Report
Order Report
3
1.2 HARDWARE SPECIFICATION
4
About Software
The language selected to develop the software should satisfy the following requirements:
It should be useful for developing application software
User-friendly package
Ability to manipulate files in minimum level
5
Visual Basic 6.0 Window:
Visual Basic 6.0 Interface consists of a form, toolbar, toolbox, menu, menu bar,
project explorer and properties window. Programming in Visual Basic 6.0 consists of a
visual programming step that involves designing its application and a code Programming
step that involves coding. Visual Basic 6.0 uses building blocks such as variables, data
files, procedures, functions and control structures in its programming environment.
Data report:
Data report is a powerful yet easy to use program for creating
custom reports lists and forms letters using data from existing database.
Textbox
The text box is the standard control that is used to receive input from the user as
well as to display the output.
Label
The label is a very useful control for Visual Basic 6.0, as it is not only used to
provide instructions and guides to the users, it can also be used to display outputs.
Command Button
The image box is another control that handles images and pictures. It functions
almost identically to the picture box. However, there is one major difference, the image in
an image box is stretchable, which means it can be resized.
6
The List Box
The function of the List Box is to present a list of items where the user can click
and select the items from the list.
The function of the Combo Box is also to present a list of items where the user
can click and select the items from the list. However, the user needs to click on the small
arrow head on the right of the combo box to see the items which are presented in a drop-
down list. In order to add items to the list, you can also use the add item method.
Data Environment
Visual Basic 6.0 powerful, sophisticated applications that exploit the key features
of MS-WINDOWS, including Multiple Document Interfaces (MDI), Object Linking and
Embedding (OLE), Dynamic Data Exchange (DDE), Graphics and more are created.
Visual Basic 6.0 let the user to add Menus, Text Box, List Box, and Scroll Bar,
File and Directory box to blank windows.
Visual Basic 6.0 also has an Intelligent Interpreter, Editor that often detects error
and even suggests the changes to correct routine programming.
User friendliness
Easier comprehension
Faster application development
Introduction to Active X technology
Develop robust stand-alone applications, games & utilities in less time that
it takes in other languages
Inter active screen handing facilities
7
INTRODUCTION TO MICROSOFT-ACCESS
Access is such a rich and powerful application that most people do not know
where to begin when they start using it. Access makes it easy for users-even beginners to
work with databases. You can create tables, edit data and se queries to find the data you
want with little effort and access includes wizards that can do the work of designing data
entry forms, reports and mailing labels for you.
Ms-access offers many new and improved features to help to create powerful data
applications. New objects, properties, methods and other language elements. Ms-access
provides an array of new and enhanced objects, methods, properties, functions,
statements, data types and events to enable to create powerful data base application with
Visual Basic 6.0.
MICROSOFT-ACCESS ACCESSIBILITY
8
2. SYSTEM STUDY
System study plays an important role of software development life cycle where
the present system is studied and requirement for the proposed system are finalized. In
manual system it has many problems, the major difficulties manual systems are tedious.
Referring the sales details of day-to-day process and calculating the transaction is very
tedious. It requires more time, cost consuming and the mistakes may occur. It is becomes
a barrier of the bunk. It has low accuracy. The requirements are not fulfilled in correct
time It yields more man power and maintenance cost is high in the fast moving world.
While preparing reports, they have to refer an account of transaction book, this becomes a
hard process.
System analysis consists of two phases planning and requirement definition .They
includes understanding problem, performing feasibility study, developing recommended
solution strategy and planning development process. System definition includes the
modules for system study. System justification tells about system project and
development environment.
9
2.3 OBJECTIVES OF THE PROPOSED SYSTEM
The proposed system has been developed to eliminate the above drawbacks. The
manual operations are carried out using computers. The details of the members are stored
in a database. Using these details, the daily transactions are updated and the management
can view the details of the transaction tables, user balances are maintained and fuel rates
can be changed in an appropriate way.
10
3. SYSTEM DESIGN
tblLogin
Purchase
Login Medicine
Admin
tblPurchase
Update
Stock
Purchase
Return
tblPurchaseReturn
tblStock
tblPayment
tblSales
Sales
Details
Payment
Details
11
E-R DIAGRAM
Mname
Mid Qty
Mid Rid
Mname
Qty tblPurReturn Update
Sid
Stock
tblSales Sales
tblStock
Medicine
Mid Qty
Payment tblSalesReturn
Sid Rid
tblPayment
Date
Bid Amt
12
3.2 DATABASE STRUCTURE
13
Table Name : Stock
Purpose : It Store the stock details
Field Name Type Size Constraints Description
Mid Number 4 Foreign Key Medicine Id
Mname Text 20 Not Null Medicine Name
Edate Date/Time 10 Not Null Expiry Date
Qty Number 10 Not Null Quality
Price Number 17 Not Null Price
14
Table Name : Sales Return
Purpose : It Store Sales Return Medicine details
15
Table Name : Order
Purpose : It Store the Order details
16
3.3 USER INTERFACE DESIGN
This design specifies the details of all forms and how it works. This project helps
to perform a medicine store work and issuing medicine in an efficient and easy manner.
Master Module
Master Module contains two forms via, Medicine Details, Buyer Details.
Medicine details form is used to store all the details about the medicine. This form has
medicine id, medicine name, expiry date, purchased from, purchased date, purchased
quantity, per quantity price. This form also stores the purchasing details and supplier
details.
The Buyer form is used to store the buyer or regular Buyer details, it will used to
get particular Buyer phone number or address to deliver medicine. This form has Buyer
id, Buyer name, address, country, contact number, email id. To view an existing Buyer
details by changing Buyer id.
The end user can easily clear, adding new record, update an existing record and
delete an unwanted records.
Transaction Module
The transaction module keeps all the daily activities in the pharmacy shop. This
module has the following forms they are, medicine purchase details, medicine purchase
return, sales, sales return, stock details, payment details.
17
The medicine purchase form is used to store the daily purchasing activities from
supplier, this form contains supplier id, supplier name, medicine id, medicine name,
number of quantity purchased, per quantity price, total amount, and purchasing date.
The stock will automatically update when the end user done a purchase, purchase
return, sales, sales return.
The purchased product has any damage it will return to the supplier this details are
stored Into the purchase return table, stock will decreased from existing stock details. The
purchase return form contains purchase id, return id, supplier name, medicine name,
expiry date purchased quantity, return quantity, return date, and remarks about the
particular medicine.
The sales form is used to store the daily medicine sales details. If made sales the
stocks will automatically reduced and sales details are stored Into the sales table. This
form has sales id, sales date, Buyer id, Buyer name, order id, medicine name, order
quantity, per quantity price, total amount. The total amount will automatically calculate
by based on sales quantity and per quantity price.
The Buyer must order before sales, because the sales process only done by base
order Buyer order details. The Buyer order details form contains order id, order date,
Buyer id, Buyer name, requested medicine id, medicine name, per quantity price, order
quantity.
Stock details are used to maintain the details such as stock id, medicine name,
type of the medicine, total quantity. Purchased medicines are easily added to stock.
Report Module
This module will help to the end user to get all the details in hard copy format. It
will created by visual basic data report. This module shows the result about medicine
details, stock report, Buyer report, sales report, Buyer details, payment details, employee
salary details.
18
4. SYSTEM TESTING & IMPLEMENTATION
SYSTEM TESTING
All tests should be traceable to Buyer requirements. The focus of testing will
shift progressively from programs. Exhaustive testing is not possible. To be more
effective, testing should be one, which has probability of finding errors.
19
Levels of Testing
Unit Testing
The first level of testing is called as unit testing. Here the different modules are
tested and the specifications produced during design for the modules. Unit testing is
essential for verification of the goal and to the test the Internal logic of the modules.
Unit test was conducted to the different modules of the project. Errors were noted down
and corrected down immediately and the program clarity was increased the testing was
carried out during the programming stage itself. In this step each module is found to be
working satisfactory as regard to the expected output from the module. The modules
like Buyer Module, Employee Module, Stock Module etc., were tested.
Validation Testing
The next level of testing is validation testing. Here the entire software is tested
the reference document for this process is the requirement and the goal is to see if the
software meets its requirements.
20
Output Testing
The output of the software should be acceptable to the system user. The output
requirement is defined during the system analysis. Testing of the software system is
done against the output requirements and the output testing was completed with success.
Performance Testing
This project is a system based project, and the modules are Interdependent with
the other modules, so the testing cannot be done module by module. So the unit testing
is not possible in the case of this driver. So this system is checked only with their
performance to check their quality.
In case of the unit testing the initialization module is first tested. Since read
module and the write module is Interdependent the performance testing is done.
SYSTEM IMPLEMENTATION
Implementation Procedures
Operation Documentation
This system is developed in such a way that the existing system facilities are
enough for implementation. The hardware facilities are sufficient enough to implement
the developed system. The system has been successfully implemented in the
organization with full co-operation of the management. The users assume their
respective responsibilities.
21
User Training
This software is being implemented on parallel basis with the ole manual system.
As this new system is more users friendly and fast, the users get more accustomed with
it. This reduces the usage of the old manual system by and by the old system is
eliminated while the new system establishes itself. By following this method if there are
any deformities in the system, it can be easily corrected by comparing with the old
system.
This system imposes the first method where one can replace a manual operation
with the computerized one. The tested system includes certain tasks while they may hold
costs risks and personal irritation to a minimum and it involves:
22
5. CONCLUSION & SUGGESTIONS
CONCLUSION
This project is efficient and gives more flexibility to the user and the organization
when comparing the manual system. This project has been aimed to minimize the burden
of clerical work and eliminate human errors. The project covers all aspects of transaction
that comes in process of managing pharmacy shop. This project has been providing
efficient report generators which provide detail information about the consumer details,
transactions and renewable reports.
SUGGESTIONS
The project can further enhanced towards providing an additional features to the
existing system when the data transaction takes place between the Buyer and the bunk.
Some of the suggested enhancements are
Change of backend database to the latest one by that time for faster response time.
Converting the single user system to a networked one, this enables multi user
access.
Introducing more facility in generating ad-hoc Buyer reports.
23
BIBLIOGRAPHY
I. BOOK REFERENCES
1. A. Russell Jones, Visual Basic 6.0, BPB Publications, First Indian Edition, 2002.
2. Elias M. Awad, System Analysis and Design, Galgotia Publications Ltd, Second
Edition, 1997.
3. Kevin Hough, Microsoft Access Database Design, BPB Publications, First Indian
Edition, 1999.
4. Ragu Ramakrishnan, Johannes Gehrke, Database Management System, Third
Edition, 1997.
5. Roger S. Pressman, Software Engineering, Tata McGraw Hill Publications, Fifth
Edition, 2001.
1. http://www.a1vbcode.com
2. http://www.google.com
3. http://www.onlinemedicalshop.com
24
II. Author reference
Acharya, Kamal. "STUDENT INFORMATION MANAGEMENT
SYSTEM." Authorea Preprints (2023).
Acharya, Kamal. "Library Management System." Available at SSRN4807104 (2019).
ACHARYA, KAMAL, et al. "LIBRARY MANAGEMENT SYSTEM." (2019).
Acharya, Kamal. "Online bus reservation system project report." Authorea
Preprints (2024).
Acharya, Kamal. "Online bus reservation system project report." (2024).
Acharya, Kamal. “Online Bus Reservation System.” SSRN ElectroNIC ASIA
Journal (2024): n. pag.
Acharya, Kamal. “Student Information Management System Project.” SSRN
ElectroNIC ASIA Journal (2024): n. pag.
Acharya, Kamal. “ATTENDANCE MANAGEMENT SYSTEM.” International
Research Journal of Modernization in Engineering Technology and
Science (2023): n. pag.
Acharya, Kamal. “College Information Management System.” SSRN ElectroNIC
ASIA Journal (2024): n. pag.
Acharya, Kamal, Attendance Management System Project (April 28, 2024).
Available at
SSRN: https://ssrn.com/abstract=4810251 or http://dx.doi.org/10.2139/ssrn.4810251
Acharya, Kamal, Online Food Order System (May 2, 2024). Available at
SSRN: https://ssrn.com/abstract=4814732 or http://dx.doi.org/10.2139/ssrn.4814732
Acharya, Kamal, University management system project. (May 1, 2024). Availableat
SSRN: https://ssrn.com/abstract=4814103 or http://dx.doi.org/10.2139/ssrn.4814103
Acharya, Kamal, Online banking management system. (May 1, 2024). Available at
SSRN: https://ssrn.com/abstract=4813597 or http://dx.doi.org/10.2139/ssrn.4813597
Acharya, Kamal, Online Job Portal Management System (May 5, 2024). Available at
SSRN: https://ssrn.com/abstract=4817534 or http://dx.doi.org/10.2139/ssrn.4817534
Acharya, Kamal, Employee leave management system. (May 7, 2024). Available
at SSRN: https://ssrn.com/abstract=4819626 or http://dx.doi.org/10.2139/ssrn.4819626
Acharya, Kamal, Online electricity billing project report. (May 7, 2024). Available at
SSRN: https://ssrn.com/abstract=4819630 or http://dx.doi.org/10.2139/ssrn.4819630
25
Acharya, Kamal, POLICY MANAGEMENT SYSTEM PROJECT REPORT. (December
10, 2023). Available at
SSRN: https://ssrn.com/abstract=4831694 or http://dx.doi.org/10.2139/ssrn.4831694
Acharya, Kamal, Online job placement system project report. (January 10, 2023).
Available at
SSRN: https://ssrn.com/abstract=4831638 or http://dx.doi.org/10.2139/ssrn.4831638
Acharya, Kamal, Software testing for project report. (May 16, 2023). Available at
SSRN: https://ssrn.com/abstract=4831028 or http://dx.doi.org/10.2139/ssrn.4831028
Acharya, Kamal, ONLINE CRIME REPORTING SYSTEM PROJECT. (August 10, 2022).
Available at
SSRN: https://ssrn.com/abstract=4831015 or http://dx.doi.org/10.2139/ssrn.4831015
Acharya, Kamal, Burber ordering system project report. (October 10, 2022). Available at
SSRN: https://ssrn.com/abstract=4832704 or http://dx.doi.org/10.2139/ssrn.4832704
Acharya, Kamal, Teachers Record Management System Project Report (December 10,
2023). Available at
SSRN: https://ssrn.com/abstract=4833821 or http://dx.doi.org/10.2139/ssrn.4833821
Acharya, Kamal, Dairy Management System Project Report (December 20, 2020).
Available at
SSRN: https://ssrn.com/abstract=4835231 or http://dx.doi.org/10.2139/ssrn.4835231
Acharya, Kamal, Electrical Shop Management System Project (December 10, 2019).
Available at
SSRN: https://ssrn.com/abstract=4835238 or http://dx.doi.org/10.2139/ssrn.4835238
Acharya, Kamal, Online book store management system project report. (Febuary 10,
2020). Available at
SSRN: https://ssrn.com/abstract=4835277 or http://dx.doi.org/10.2139/ssrn.4835277
Acharya, Kamal, Paint shop management system project report. (January 10, 2019).
Available at
SSRN: https://ssrn.com/abstract=4835441 or http://dx.doi.org/10.2139/ssrn.4835441
Acharya, Kamal, Supermarket billing system project report. (August 10, 2021). Available
at SSRN: https://ssrn.com/abstract=4835474 or http://dx.doi.org/10.2139/ssrn.4835474
26