INTRODUCTION

1. INTRODUCTION

1.1 ABOUT THE PROJECT

This project entitled with Pharmacy Management System. This application developed
using VB.NET technology as front end and backend is MYSQL.
Pharmacy Management system are employed in regulatory control and drug management,
community pharmacy, hospital pharmacy, the pharmaceutical industry, academic activities,
training of other health workers, and research. In all these fields, their aim is to ensure optimum
drug therapy, both by contributing to the preparation, supply and control of medicines and
associated products, and by providing information and advice to those who prescribe or use
pharmaceutical products.

Pharmacy management system can make the work easier by giving the details of the
medicine when its name is entered. A computer gives the details of the medicine like rate of
medicine. It becomes very difficult in big medical stores to handle the details of all the
medicines manually, so by using this pharmacy manage system we can maintain the records of
all the medicines.

A pharmacy information system must retrieve process and update the information it
obtains for safe and effective use of drugs. It is used to manage drug usage in the patient health
care process and to communicate a large volume of information to pharmacy and
pharmaceutical firms. The pharmacy information system is normally used to support activities
and the inventory. Pharmaceutical companies had developed some relationship, on marketing
issues, with hospital pharmacies. The findings were in favor of further therapeutic activities by
pharmacy information systems, which could be achieved by improving relationship between
hospitals and pharmaceutical firms, particularly in Tehran.

1.2 Modules Description:

It has been modularized into following modules.

• Administrator Module
 • Pharmacist Module
• Cashier Module
• Manager Module

Administrator Module:

• Pharmacist
In that Admin can add new pharmacist and can view the pharmacists list. And
He has the rights of delete Pharmacist Details.
• Manager
In that Admin can add new Manager and can view the Details Of Managers
And He has the rights of delete Manager Details.

• Cashier
In that Admin can add new cashier and can view the Details Of Cashier And
He has the rights of delete Cashier Details.

Pharmacist Module
Pharmacist Module used to add and view the prescription list.
He can Maintain Stock Details and add new Medicines.
This module gives the following details:
• Prescription
• Stock
Cashier Module
Cashier Module can collect the bills and cash. This Modules Maintain the all Process
of Payment details.
This module gives the following details
• Process payment (include invoice no, payment type, s.no etc..)
Manager Module
Manager Module used to view the users Details and Prescription Details.
And Can Add new medicines,View Medicine details.
This module gives the following details
 • View Users
• View Prescription details
• Manage Medicine Details

SYSTEM STUDY
2. SYSTEM STUDY

2.1 EXISTING SYSTEM

Hospital pharmacy supervision is to ensure that medicines are accessed and used
safely by patients and professionals both within the environments of a hospital and beyond.
Pharmacy involves information processing, which means retrieving information from one file
and using it to compare, update, or display information from another file. The pharmacist could
play an essential role in providing accurate data for managing patient care. Information systems
are now necessary to help pharmacists to perform their expanding list of daily tasks efficiently.
2.2 PROPOSED SYSTEM

Hospital pharmacy supervision is to ensure that medicines are accessed and used safely
by patients and professionals both within the environments of a hospital and beyond. Pharmacy
involves information processing, which means retrieving information from one file and using
it to compare, update, or display information from another file. The pharmacist could play an
essential role in providing accurate data for managing patient care. Information systems are
now necessary to help pharmacists to perform their expanding list of daily tasks efficiently.
The pharmacy information system collects,stores and manages information related to drugs
and supervises the use of drugs in line with patient care. The pharmacy information system can
rely on management information system to track and dispense drugs to hospitals and health
care organizations. Pharmacy information systems are also among the most widely used
clinical information systems today.
 SYSTEM CONFIGURATION
3. SYSTEM CONFIGURATION

3.1 Hardware configuration

RAM : 2 GB and above

Hard Disk: 120 GB and above

3.2Software configuration

Front end: VB.NET

Back end: Mysql

Server : XAMP

3.3 SOFTWARE FEATURES:

Design Features

Open Source:

VB.NET is freely available for use. The community of open source VB.NET developers
provides technical support and is constantly improving updating the core VB.NET
functionalities. VB.NET is available at free of cost under VB.NET General Public License and
most of its associative required software's like MySQL, Text Editors and Apache Server are
also freely available, so it proves very cost effective for the developers.

Cross-Platform:

VB.NET provides high compatibility with leading operating systems and web servers
such as thereby enabling it to be easily deployed across several different platforms.VB.NET
scripts can run across operating systems such as Linux, Windows, Solaris, OpenBSD, Mac
OSX etc and also provide support for all major web servers such as Apache, IIS, iPlanet etc.

Power:

Several web tasks can now be easily perform using VB.NET. For example now we can
develop from small websites to giant business and organizational websites, informative forums,
chatting platforms, CRM solutions, e-commerce shopping carts, community websites, e-
business, shopping carts and gigantic database driven sites.

User Friendly:

Designed in a user friendly manner, VB.NET gives more flexibility than C, C++ and
ASP and overall helps in increasing traffic to the site.

Quick:

VB.NET is designed to work well with the web, and so things like accessing the GET
and POST and working with HTML and URLs are built-ins in the VB.NET language. This
makes it really concise and straightforward to make a website.

Extensions:

Being an open source language, a large number of libraries and extensions, to extend
its core functionalities, are available for download. The source code of VB.NET can be
modified to include custom created extensions and components thereby increasing its
extensibility.

Easy Deployment:

There are many hosting companies that will, for a few dollars a month, give you a server
running VB.NET so you can make a website really easily.
Automatically Refreshes:

Nowadays developing dynamic websites are in the huge demand due to its specific
characteristics like it automatically refreshes and does not need to make much changes
manually.

Community Support:

A huge advantage that VB.NET offers is its community. If you are looking for a
particular script, chances are another user has already created something similar. Check within
the VB.NET community for availability. Likewise, if you have created a function that others
might enjoy, be sure to post the code for others.

Other Tools:

If you need to access other web based tools like Google maps (which is always
advisable for a business website), or any other, VB.NET makes it easy to access.

Security:

VB.NET offers security as well that helps prevent malicious attacks. These security
levels can be adjusted in the .ini file.

Talent Availability:

You can hire VB.NET programmers more easily than any other language programmers
since so many people know the language.

INTRODUCTION TO MYSQL

Mysql is a powerful database. It’s very good and free of change. Many developers in
the world selected Mysql and VB.NET for developing their website.

The Mysql database has become the world’s most popular open source database
because of its consistent fast performance, high reliability and ease of use. It’s used in more
than 6 million installations ranging from large corporations to specialized embedded
applications on every continent in the world.
 Not only is Mysql the world’s most popular open source database, it’s also become the
database of choice for a new generation of applications built on the LAMP stack(Linux,
Apache, Mysql, VB.NET / Perl / python.) Mysql runs on more than 20 platforms including
Linux, Window, OS/X, HP-UX, AIX, Netware, giving you the kind of flexibility that puts you
in control.

Whether you’re new to database technology or an experienced developer or DBA,

Mysql offers a comprehensive range of certified software, support, training and consulting to
make you successful.MYSQL is a free, widely used SQL engine. It can be used as a fast
database as well as a rock-solid DBMS using modular engine architecture.

The purpose of this wiki book is to provide a practical knowledge on using the database from
two points of view:

• application developer: learn about SQL basics, VB.NET Main, query optimization
• system administrator: learn about installation, security, maintenance, failover, high
availability

MYSQL Language

DDL (Data Definition Language) refers to the CREATE, ALTER and DROP
statements.

DDL allows adding / modifying / deleting the logical structures which contain the data or which
allow users to access / maintains the data (databases, tables, keys, views...). DDL is about
"metadata".

DCL is used to grant / revoke permissions on databases and their contents. DCL is
simple, but MYSQL's permissions are rather complex. DCL is about security.

Mysql Homepage
1. Scalability and Flexibility
The Mysql database server provides the ultimate in scalability, sporting the capacity to
handle deeply embedded applications with a footprint of only 1MB to running massive data
warehouses holding terabytes of information.
2. High Performance
A unique storage-engine architecture allows database professional to configure the
Mysql database server specifically for particular applications, with the end result being
amazing performance results.
3. High Availability
Rock-solid reliability and constant availability are hallmarks of Mysql, with customers
relying on Mysql to guarantee around-the-clock uptime.

4. Robust Transactional Support

Mysql offers one of the most powerful transactional database engines on the market.
Features include complete ACID (atomic, consistent, isolated, durable) transaction support,
unlimited row-level locking, distributed transaction capability, and multi-version transaction
support where readers never block writers and vice-versa.
5. Web and Data Warehouse Strengths
Mysql is the de-facto standard for high-traffic website because of its high-performance
query engine, tremendously fast data inserts capability, and strong support for specialized web
functions like fast full text searches.
6. Strong Data Protection
Because guarding the data assets of corporations is the number one job of database
professionals, Mysql offers exceptional security features that ensure absolute data protection.
7. Comprehensive Application Development
One of the reasons Mysql is the world’s most popular open source database is that it
provides comprehensive support for every application development need.
8. Management Ease
This rule holds true whether the platform is Microsoft Windows, Linux, Macintosh, or
UNIX. Once installed, Self-management features like automatic space expansion, auto-restart,
and dynamic configuration changes take much of the burden off already overworked database
administrators.
 4. SYSTEM DESIGN

4.1DATA FLOW DIAGRAM

LEVEL 0:

Admin Details Data Flow:

Level 1:
Level 2:
Level 3:
4.2 INPUT DESIGN:
Input design is the method by which valid data are accepted from the user. The valid
data turn is stored as operational data in the database. Incorrect input data are the most common
cause of errors in the data processing. The input design is carried out in such a way that the
input screens are user friendly. The goals of designing input design are to make input data entry
as easy and error free. Input screen takes care to filter the valid data from being becoming an
operational data at data entry phase.
Input design is the part of the overall system design that careful attention and is the
most expensive phase. It is the point of most contact for the users with the system and so it is
prone to errors.
4.3 DATA BASE DESIGN:
Table Design:

Table Name : admin

Column Name Data Type Description

Admin_id Int Primary Key

Username Varchar username for login

Password Varchar Password for login

Date Datetime Datetime of account created

Table Name :Cashier

Column Data Type Description

Name

cashier_id int Primary Key

first_name varchar Firstname of cashier

last_name varchar Lastname of cashier

Staff_id varchar Staffid of cashier

postal_addr varchar Postal address of cashier

ess

Phone varchar Phone number of cashier

Email varchar Email of cashier

Username varchar Username of cashier

Password varchar Password of cashier

Date datetime Date created

Table Name :Manager

 Column Name Data Type Description

manager_id int Primary Key

first_name varchar Firstname of manager

last_name varchar Lastname of manager

Staff_id varchar Staffid of manager

postal_address varchar Postal address of manager

Phone varchar Phone number of manager

Email varchar Email of manager

Username varchar Username of manager

Password varchar Password of manager

Date datetime Date created

Table Name: Payment Types

Column Name Data Type Description

Id int Primary Key

Name varchar Name of Payment Type

Table Name : Pharmacist

Column Name Data Type Description

pharmacist_id int Primary Key

first_name varchar Firstname of pharmacist

last_name varchar Lastname of pharmacist

Staff_id varchar Staffid of pharmacist

postal_address varchar Postal address of pharmacist

Phone varchar Phone number of pharmacist

Email varchar Email of pharmacist

Username varchar Username of pharmacist

Password varchar Password of pharmacist

Date datetime Date created

Table Name :Prescription

Column Name Data Type Description

Id int Primary Key

prescription_id int Id of prescription

customer_id int Id of customer

customer_name varchar Name of customer

Age varchar Age of customer

Sex varchar Sex of customer

postal_address varchar Postal address of customer

invoice_id varchar Id of Invoice

Phone varchar Phone Number

Date datetime Date created

Table Name :Prescription Details

Column Name Data Type Description

 Id int Primary Key

prescription_id int Id of prescription

drug_name int Name of Drug

Strength varchar Strength of medicine

Dose varchar Dose of medicine

Quantity int Quantity of medicine

Table Name :Receipts

Column Name Data Type Description

Receiptno int Primary Key

customer_id varchar(10) Id of customer

Total int(10) Total amount

Paytype varchar Type of Payment

Serialno varchar Serialno of receipt

served_by varchar Receipt served by

Date timestamp Date of receipt given

Table Name :stock

Column Name Data Type Description

Stock_id int Primary Key

drug_name varchar Name of drug

Category varchar Category

Description varchar Description about stock

Company varchar Related company

Supplier varchar Supplier Detail

Quantity varchar Quantity Left

Cost varchar Cost of drug

Status enum Status of availability

Date_supplied datetime Date of supplied

Table Name :tempprescription

Column Name Data Type Description

Id int Primary Key

customer_id int Id of customer

customer_name varchar Name of customer

Age varchar Age of customer

Sex varchar Sex of customer

postal_address varchar Postal address of customer

Phone varchar Phone Number

drug_name varchar Name of Drug

Strength varchar Strength of Drug

Dose varchar Dose of Drug

Quantity varchar Quantity given

4.4 OUTPUT DESIGN:

The output design defines the output required and the format in which it is to be
produced. Care must be given to present the right information.
The output is the most important and direct source of information to the user. Efficient,
output design should improve the systems relationship with the user and helps in decision
making. A major form of output is a hard copy from the printer. Printouts should be designed
around the output requirement to the user. The standard that is maintained for output design is
clear. Output provides a permanent copy of the results for the later consultation.
 SYSTEM TESTING AND IMPLEMENTATION
5.1 SYSTEM TESTING
INTRODUCTION:
Software testing is a critical element of software quality assurance and represents the
ultimate review of specification, design and coding. In fact, testing is the one step in the
software engineering process that could be viewed as destructive rather than constructive.

A strategy for software testing integrates software test case design methods into a well-
planned series of steps that result in the successful construction of software. Testing is the set
of activities that can be planned in advance and conducted systematically. The underlying
motivation of program testing is to affirm software quality with methods that can economically
and effectively apply to both strategic to both large and small-scale systems.
STRATEGIC APPROACH TO SOFTWARE TESTING
The software engineering process can be viewed as a spiral. Initially system engineering
defines the role of software and leads to software requirement analysis where the information
domain, functions, behavior, performance, constraints and validation criteria for software are
established. Moving inward along the spiral, we come to design and finally to coding. To
develop computer software we spiral in along streamlines that decrease the level of abstraction
on each turn.
 A strategy for software testing may also be viewed in the context of the spiral. Unit testing
begins at the vertex of the spiral and concentrates on each unit of the software as implemented
in source code. Testing progress by moving outward along the spiral to integration testing,
where the focus is on the design and the construction of the software architecture. Talking
another turn on outward on the spiral we encounter validation testing where requirements
established as part of software requirements analysis are validated against the software that has
been constructed. Finally we arrive at system testing, where the software and other system
elements are tested as a whole.

UNIT TESTING

MODULE TESTING

Component Testing SUB-SYSTEM

TESTING

SYSTEM
TESTING
Integration Testing

ACCEPTANCE TESTING

User Testing
UNIT TESTING

Unit testing focuses verification effort on the smallest unit of software design, the
module. The unit testing we have is white box oriented and some modules the steps are
conducted in parallel.

1. WHITE BOX TESTING

This type of testing ensures that

• All independent paths have been exercised at least once
• All logical decisions have been exercised on their true and false sides
• All loops are executed at their boundaries and within their operational bounds
• All internal data structures have been exercised to assure their validity.
To follow the concept of white box testing we have tested each form .we have created
independently to verify that Data flow is correct, All conditions are exercised to check their
validity, All loops are executed on their boundaries.

2. BASIC PATH TESTING

Established technique of flow graph with Cyclometric complexity was used to derive
test cases for all the functions. The main steps in deriving test cases were:
Use the design of the code and draw correspondent flow graph.
Determine the Cyclometric complexity of resultant flow graph, using formula:
V(G)=E-N+2 or
V (G) =P+1 or
V (G) =Number of Regions
Where V (G) is Cyclometric complexity,
E is the number of edges,
N is the number of flow graph nodes,
P is the number of predicate nodes.

3. CONDITIONAL TESTING
In this part of the testing each of the conditions were tested to both true and false aspects. And
all the resulting paths were tested. So that each path that may be generate on particular
condition is traced to uncover any possible errors.

4. DATA FLOW TESTING

This type of testing selects the path of the program according to the location of
definition and use of variables. This kind of testing was used only when some local variable
were declared. The definition-use chain method was used in this type of testing. These were
particularly useful in nested statements.

INTEGRATION TESTING

Integration testing is a systematic technique for constructing tests to uncover error

associated within the interface. In the project, all the modules are combined and then the
entire programmer is tested as a whole. In the integration-testing step, all the error uncovered
is corrected for the next testing steps
5.2 SYSTEM IMPLEMENTATION:

The Implementation Plan describes how the information system will be deployed,
installed and transitioned into an operational system. The plan contains an overview of the
system, a brief description of the major tasks involved in the implementation, the overall
resources needed to support the implementation effort (such as hardware, software. facilities,
materials, and personnel), and any site-specific implementation requirements. The plan is
developed during the Design Phase and is updated during the Development Phase; the final
version is provided in the Integration and Test Phase and is used for guidance during the
Implementation Phase.
5.3 SYSTEM MAINTENANCE:

Every system has to perform Maintenance at some point or another. Whether it’s just
to upgrade a portion of the system or because of some problem with the system, it’s an
inevitable fact of operating system. And in many cases, maintenance requires taking your
system for at least a few minutes.

SCREEN SHORT AND CODE

A.SAMPLE FORM
DATABASE
 CONCLUSION
6.CONCLUSION
It has been a great pleasure for me to work on this exciting and
challenging project. This project proved good for me as it provided
practical knowledge of programming in VB.NET web based application and
MYSQL Server, and also about all handling procedure related with “Pharmacy
Management System”. It also provides knowledge about the latest technology
used in developing web enabled application and client server technology
that will be great demand in future. This will provide better
opportunities and guidance in future in developing projects
independently.
 FUTURE ENHANCEMENTS
7.FUTURE ENHANCEMENTS
Currently the Pharmacy Management System is to enhance and upgrade the existing system by
increasing its efficiency and effectiveness. The software improves the working methods by
replacing the existing manual system with the computer-based system. One of the main future
enhancements in our system, we will include BAR CODE facility using the bar code reader,
which will detect the expiry date and the other information about the related medicines.
 BIBLIOGRAPHY
8. BIBLIOGRAPHY
SYSTEM ANALYSIS AND DESIGN : MARSHALL KIRK McKUSICK
VB.NET & MYSQL SERVER THOMSON : LUKE WELLING, LAURA
DESIGN MYSQL : GUYHARRISON, STEVEN
FEUERSTEIN
VB.NET DEVELOPER GUIDE : BARTOSZ POREBSKI, KAROL
PRZYSTALSKI, LESZEK NOWAK

WEB SITES:
For VB.NET & Mysql installation:
http://VB.NET.net/manual/en/install.VB.NET
http://VB.NET.net/manual/en/install.windows.VB.NET

for Dreamweaver installation:

http://webdesign.about.com/od/dreamweaverhowtos/ht/htdwinstallw8.htm
http://www.siteground.com/tutorials/dreamweaver/dreamweaver_installation.htm