FACULTY OF BUSINESS & ECONOMICS
of management information system
by: AMMAR KHALED AL-ASBAHI
2. RELATED WORKS: 5
2.1 Disadvantages of old
2.2 Advantages of new
2.3 IMPORTANCE OF
2.4 Goals &
Objectives of pharmacy management system: 7
2.5 Utilization of
pharmacy management system: 8
2.6 Functionalities provided by Pharmacy Management
System are as follows; 9
3. PROPOSED METHODOLOGY: 10
3.1 System Analysis. 10
3.2. Visual Studio 2017. 12
3.2. SQL 2014. 13
This project is aimed at developing a desktop based application named
Pharmacy Management System for managing the Pharmacy system of any
organization. The Pharmacy Management System (PMS) refers to the system and
processes to manage the stock of organization with the involvement of
Technology system. This system can be used to store the details of the
Pharmacy, stock maintenance, update the Pharmacy based on the sales details,
generate sales and Pharmacy report daily or weekly base. This project is categorized
individual aspects of the sales and Pharmacy management system. In this system,
we are solving a different problem affecting to direct sales management and
Pharmacy Management System is important to ensure quality control in businesses
that handle transactions resolving around consumer goods. Without proper
Pharmacy control, a large retail store may run out of stock on an important
item. A good Pharmacy management system will alert the wholesaler when it is
time to record. Pharmacy Management System is also of important means of
automatically tracking large shipment. An automated Pharmacy Management System
helps to minimize the errors while recording the stock.
The development of pharmacy management system what is meant here is the process of automating any conversion from work depends on the human effort in everything to work based on information technology or building the information system of the company The purpose of the automation or establishment of the information system of the company is to reduce errors and achieve the highest rate of validity of data entered and reduce the cost by combining the data shared in a single database while maintaining the independence and purpose of control and relationship and maintain their exit from reports as they are according to their importance in the manual system. Also, the system of the company helps in the decision-making processes easily and accurately since the information system stores all the data is the main source of information if the accuracy of the data and the availability of information accurately and the system helped speed decision-making appropriate, helps in the planning and control of the company and reducing the time for workers which leads to any reduction in cost. These reasons lead to achieving the highest rate of profitability to the organization that wants to automate its work. Making automation of the work and the establishment of information systems for the organizations is very important to achieve the full administrative success of any system, whatever type of work. Mechanization occurs as a natural result in the life cycle of systems.Life cycle model of systems: It is meant that any system has a period of time and then become unusable for any non-compatible with the current environment and must be replaced by a new system or developed to match the current environment, For example, the current pharmacy management system, which is mechanized in the past, relies on records and manual works in everything. It is now no longer compatible with the current environment. It will be replaced by a new system based on computer and information technology to be more in line with the surrounding environment.There are several systematic steps within the life cycle model of systems. This project has four main processes:· Part 1: The area of research or study and its importance for science, technology or national economy · Part 2: What was done in this area before and what problems were still not solved or solved not satisfactory Part. · Part 3: What is the goal of this paper and what is new in the proposed method Part.· Part 4: Outline of the paper.
2. RELATED WORKS:
2.1 Disadvantages of old system
know the manual process is quite tedious, time-consuming, less accurate in
comparison to computerized processing. Obviously, the present system is not is
exception consultant encountering all the above problems.
It is very tedious.
All information is not placed separately.
Lot of paperwork.
Slow data processing, not the
It is difficult to found records due file
2.2 Advantages of new system
new computerized system, I tried to give these facilities.
Manually system changes into the
Friendly user interface.
Time-saving. Paper Saving
Connecting to the database so we use a
different type of queries, data report. Give facility of different type of
Data are easily to modifying.
2.3 IMPORTANCE OF PROBLEM
To computerize all details regarding
importer, customer details & pharmacy details.
To automate the process of ward entries.
To maintain records effectively.
To manage a current store of pharmacy and
The project has information regarding the
importer details, customer
Details, billing details and sales
This project includes modules such as
special authentication to each user
place in store
discount for item
and buy billing
2.4 Goals & Objectives of pharmacy
Pharmacy Management Module: Used for
managing the Pharmacy details.
Module: Used for managing the details of Pharmacy
Sells Module Used for managing the details
Medicines Management Module: Used for
managing the information and details of the Medicines.
Stocks Module _ Used to manage ng the
Company Module: Used for managing the
Login Module. Used for managing the login
Users Module Used to manage ng the users
of the system
2.5 Utilization of pharmacy management
help collecting perfect management in details. In a very short time, the
collection will be obvious, simple and sensible. It will help a person to know
the Management of passed year perfectly and vividly. It also helps in current
all works relative to Pharmacy Management System. It will be also reduced the
cost of collecting the management and collection procedure will go on smoothly.
My project aims at Business process
automation; I have tried to computerize various processes of Pharmacy
Management System. In the computer system the person has to fill the various
forms number of copies of the forms can be easily generated at a time. Additionally,
it’s not necessary to create the manifest but we can directly print it, which
saves our time.
To assist the staff and capturing the
effort spent on their respective working areas.
To utilize resources in an efficient
manner by increasing their productivity through automation.
The system generates types of information
that can be used for various purposes.
It satisfies the user requirement
Be easy to understand by the user and
Be easy to operate
Have a good user interface
Delivered on schedule within the budget
2.6 Functionalities provided by Pharmacy Management
System are as follows;
Provides the searching
facilities based on various factors. Such as Pharmacy,
Stocks, Company, Pharmacy.
Pharmacy Management System
also manages the Sells details online
Company details, Pharmacy
It tracks all the information
of Medicines, Sells, Company etc
Manage the information on
Shows the information and
description of the Pharmacy, Stocks
To increase efficiency of
managing the Pharmacy, Medicines
It deals with monitoring the
information and transactions of Company.
Manage the information of
Editing, adding and updating
of Records s improved which results in n proper resource management of Pharmacy
Manage the information of
Integration of all records of
Reports of Pharmacy Management
It generates the report on
Pharmacy, Medicines, Sells
Provide filter reports on
Stocks, Company, Pharmacy
You can easily export PDF for
the Pharmacy, Sells, Company
Application also provides
excel export for Medicines, Stocks, Pharmacy
You can also export the report
into CSV format for Pharmacy, Medicines, Pharmacy
3. PROPOSED METHODOLOGY:
When a student has an
idea for a Graduation project to be graduate from university, how does that
idea become reality? How do they go about making it happen? I selected the systems-development
life cycle (SDLC).
3.1 System Analysis
To create this system, it
needs serval of tools and environment is used for developing the proposed of
the project. The Programming that software is created by programming is the
process of making a set of order and logical instructions for a digital device
to follow using a programming language. The functional of programming is
usually called coding in order to the syntax of a programming language is not
in a form that all can understand it is in code. The process of developing a
software is not always easy, sitting down and writing some code.
Core 2 duo or higher
1 GB or Greater
120 GB(Free space )
Plug and play monitor
Microsoft PS/2 MOUSE
Standard 101/102 key
Visual Studio 2017
3.2. Visual Studio 2017
The main integrated development environment of
Microsoft. Allows programming of the scripts along with Web services, Web
applications, Web sites and Windows Form supported by Microsoft Windows,
Windows Mobile, . Net Framework and Microsoft Silverlight.
Visual Studio has a code editor that supports
Intelligence technology and code rewriting. It also contains an interpreter
that detects run-time errors. The interpreter detects spelling errors in codes.
It also includes a sample designer to build a graphical user interface, a web
designer, and a class designer. Data and designer for crystal reports.
The Visual Studio contains a code editor that supports
syntax and automatic completion. It also uses smart technology to asset the
programmer to write variables, functions, methods, and courses quickly. The
editor supports the writing of all the programming and coding languages
??contained in the Visual Studio.
Visual Studio’s code editor also supports the ability
to bookmark the code to help with fast browsing, also supports the possibility
of collapsing and expanding code groups, searching and replacing in code, and
also supports code snippets, which are ready templates of code to be inserted
and changes within the projects in progress. Also the possibility of rewriting
A development environment and a programming language
from Microsoft based on the famous BASIC language. They are categorized as
object programming languages. Since Microsoft began to release Visual Basic, it
has been very successful and popular among programmers because of its extreme
ease in the face of the extreme complexity faced by any programmer seeking to
program Windows using C or C ++. Overall, Visual Basic complies with database
and application applications for small businesses and account software. It is
convenient, easy and purpose-oriented. It also allows the programmer to focus
on solving the problem. He often has no technical difficulties when writing a
Visual Basic program. However, it should be noted that the Visual Basic programs
are not fully translated into machine language such as C ++ or Delphi, but
translated into a middle code that communicates with a “Run Time
library” called MSVBM.dll with the replacement of question marks with the
SQL stands for Structured Query Language Is a relational database program produced by Microsoft, the main function
for it save and update and modifying the data is coming from c programming and
it is had a lot of advantage:
SQL Server allows you to manage and exploit vast amounts of
data smoothly and securely. in SQL Server solutions provide you hours of time
and minimize errors with built-in compression and partitioning. And with the
use of a huge amount of data and the growth of the institution continuously and
add more and more devices. Finding a solution can be very costly and
inefficient. SQL Server Capability Data compression, backup and database can be
an advantage for organizations seeking to increase space and processing power
without incurring excessive costs or maintaining and producing headaches.
With SQL Server, you can manage multiple types of data
through a single database to get the greatest value from your data. This may
mean showing profits from different projects along with relevant data that can
show your business success and work to improve them. will work with your
company on its goals to integrate your data in a way that specifically serves
your best needs.
SQL Server enables users to make data easy to recover with
built-in data mining integrates SQL Server into familiar tools like Microsoft
Word and Excel, bringing your data directly to your fingertips.
Whether it is government regulations, medical
compliance, or to meet the specific needs of the organization, auditing can be
a daunting, complex task. SQL Server in Audit provides a centralized mechanism
to capture a database server or related procedures.
3.3 .Net Framework
This Is a Microsoft programmatic framework for running
programs that can be installed on computers loaded with Microsoft Windows
operating systems. It is usually supplied with the operating system (for both
client and server as well as for mobile). The operating system includes Windows
Vista and Windows Server 2008. It is available free of charge on the Microsoft
website for download for Windows XP and Windows Server 2003. The .NET Framework
is also available for download from the site, but as a separate version.
The .NET Framework is a link between the program and
the operating system, to produce or run programs independent of the machine, ie
programs that can work regardless of the environment and the device on which
you work, only provide a .NET Framework for the programs originally built for
The .net framework stands between the operating system
and our software, and the operating system stands between it and the hardware.
This brings the picture closer to understanding. The software requests services
from the .NET framework, and the framework connects these requests to the
operating system. Here is the most important feature of the Dot Net (the
ability to work on any device). Net to the operating system by type, and the
operating system to hardware by type, our program, which we wrote on Windows
XP, for example, when running on Vista, the same orders Which we wrote on XP
will be implemented in Vista because the Dot Net framework can “speak XP
and can speak Vista”, which frees the programmer from rewriting his
program for each system. “Any device” means: laptops, mobile phones.