FACULTY OF BUSINESS & ECONOMICS
of management information system
by: AMMAR KHALED AL-ASBAHI
2. RELATED WORKS: 5
2.1 Disadvantages of old system.. 5
2.2 Advantages of new system.. 6
2.3 IMPORTANCE OF PROBLEM… 6
2.4 Goals & Objectives of pharmacy management
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.1.2Software specification. 11
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 user-friendly
It is difficult to found records due file management
2.2 Advantages of new system
new computerized system, I tried to give these facilities.
Manually system changes into the computerized system.
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 inquiry
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 availability.
The project has information regarding the importer
Details, billing details and sales details.
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
Module: Used for managing the details of Pharmacy
Sells Module Used for managing the details of Sells
Medicines Management Module: Used for managing the
information and details of the Medicines.
Stocks Module _ Used to manage ng the Stocks details
Company Module: Used for managing the Company
Login Module. Used for managing the login details
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 operator
Be easy to operate
Have a good user interface
Delivered on schedule within the budget
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
Company details, Pharmacy details, Pharmacy.
It tracks all the information of Medicines, Sells,
Manage the information on Medicines
Shows the information and description of the Pharmacy,
To increase efficiency of managing the Pharmacy,
It deals with monitoring the information and
transactions of Company.
Manage the information of Pharmacy
Editing, adding and updating of Records s improved
which results in n proper resource management of Pharmacy data.
Manage the information of company
Integration of all records of Pharmacy
Reports of Pharmacy Management System:
It generates the report on Pharmacy, Medicines, Sells
Provide filter reports on Stocks, Company,
You can easily export PDF for the Pharmacy, Sells,
Application also provides excel export for Medicines,
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.
Ease of use
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.