Abstract
An information system is an arrangement of people, data, processes, interfaces, networks, and technology that interact for the purpose of supporting and improving both day-to-day operations in a business.
Our application will talk about one of the Hospital Information System (HIS) subsystem and it is the Pharmacy Information System (PIS) or warehouse management information system, here we see ZAGAZIG university hospital's pharmacies and inventories have two main problems, software problem and connection problem (as main inventories are varies up 500 meter fare from pharmacies ). Software problems like: Poor interface, Most of its work was done by inventory's pharmacists (unjustly between inventories and pharmacies), Most of processing operations done manually by pharmacists (average, forecast…), some reports were made manually, Hardware problems were found (wrong in network planning), some operating system problems (OS) were found and it Need continual maintain.
The hospitals already have a plan to solve connection problem by connecting main inventories with others pharmacies using wireless connection but it have many disadvantage. So our application targets are to solve connection problem and to develop new application. This application name is SAMya (SAM pharmacy application), SAMya is a pharmacy information system which treats ZAGAZIG university main inventories and pharmacies software problem.
For connection problem which could be solve by making two databases in main inventories and pharmacies and let them synchronize once at the end of every day using internal phone lines (no more costs), or by making one database in inventories and make direct link between two internal phone lines, We won't discuss this problem in this project.
As any software we must collect data from inventories and pharmacies by direct interviewing and observation for status and paper cycles, the supervisor for all inventories provide most data (also papers) wanted in project, then the other pharmacists. After every interview we sort the output of it, then making new blocks to contain the papers data and all provided information.
Then we started in the next step its ANALYSIS, and making models that represent all what happened in any inventory and pharmacy, to know application objectives, input data, output data and data manipulation. The next step was building Entity Relationship diagram (relational database), then building Sybase PowerDesigner Physical Data Model (PDM) and make the database (SQL format) preceded by building and reverse engineering actions between PDM and Conceptual Data Model (CDM).
Now the application database is ready to install, just make some test records, then add users roles. Finally install the database followed by interface developing and report design.