MEDICAL STORE INVENTORY AND BILLING MANAGEMENT SYSTEM PROJECT REPORT

MEDICAL STORE INVENTORY AND BILLING MANAGEMENT SYSTEM PROJECT REPORT

PROJECT REPORT

MEDICAL INVENTORY MANAGEMENT SYSTEM PROJECT REPORT

PROJECT SOURCE CODE

MEDICAL INVENTORY MANAGEMENT SYSTEM PROJECT SOURCE CODE

FREE DOWNLOAD ALL THE PROJECT REPORTS WITH SOURCE CODE FROM HERE

OTHER PROJECT REPORTS YOU SHOULD REVIEW

Medical Shop Management System Project Report

MEDICAL STORE MANAGEMENT SYSTEM PROJECT SOURCE CODE

ABSTRACT

Our project Medical Inventory System mainly focus on the different medical related item sales/return system, which is highly user friendly easy to use, where in user can easy sales/return of item. 

We have developed this Medical Inventory System as our semester project with a view to get familiar with the technology as well as with windows utility. 

Our system mainly deals with different type of Medical item, customer, dealer very easily. 

Since we had time constraints we were not able to make out module into live and living portal but would try for the same together with the interference.

                    Table of Contents

               

SR.NO	Topic	Page no
1	Introduction	6
2	System Requirement  Specification	9
3	Problem Identification	11
4	System Analysis	13
5	Priliminary Investigation	16
6	Feasibility Study	18
7	Problem Analysis	20
8	System Development Strategies	22
9	System Engg Paradigm Applied	24
10	Information gathering	28
11	System Flow Diagram	30
12	Data Flow Diagram	33
13	Data Dictionary	39
14	E-R Diagram	45
15	Input Design	48
16	Output Design	61
17	Testing And Implementation plan	69
18	Further Enhancement Of The System	70
19	Bibliography	71

                                    

SYSTEM REQUIREMENT SPECIFICATION

Software  Requirement     

Development Side 

Microsoft xp service pack 2 or upwards 

Sql Server 2008 

MS Office 2007 

MS Visual Studio 2008 

Crystal report 9.0 on later 

Client Side 

Microsoft xp service pack 2 or upwards 

Sql Server 2008 

Microsoft .Net Framework 3.5 

Hardware Requirement 

  

Development Side 

CPU : Pentium-IV processor or any processor. 

HARD DISK : 40 GB or above. 

RAM : 256 MB or above. 

Client Side

Ø  CPU                          :   Pentium-IV  processor or any processor.

Ø  HARDDISK               :  40 GB or above.

Ø  RAM                        :   256 MB or above.   

Ø  DEVICE                    :    printer

PROBLEM IDENTIFICATION

Existing System

The existing Medical Store System is manual system.The main drawback of the existing system is time consumption. There are number of records and hence a larger number of registers have to be kept to the store.

This document required more storing space, more manpower and job become tedious.
In Existing system following points are observed:



chances of errors and data processing time

Timely Due to manual process, required more time to complete user requirement

It will increase updating is complicated.

Security of data were not maintain

Need For The New System

The existing of Medical Store System is manually which require more paper work so it needs to computerized the system to get following benefits.

Computer enhances easy and simple means of Storing information. The space occupied for storing of information is reduced.

Computers helps in fast retrieval of information .we can search information in a short of time.

Maintenance of data is very easy and workload is reduced.

It’s a paperless system.

We can generated report on demand.

It will give faster modification. 

SYSTEM ANALYSIS - MEDICAL STORE INVENTORY AND BILLING MANAGEMENT SYSTEM

Requirement analysis is a software engineering task that bridges the gap between system engineering and software design. It provides the software designer with a representation of information and function that can be translated to data.

Before developing any computerized system, it is imperative to examine initially. The problem in the exiting system and also ascertain the basic needs that should be fulfilled by the proposed system the primary aspect of developing a full 1 fledged automated system would be to learn the current procedure and the information flow to locate the problem in the exiting system to identify what resources are used to discuss with user and their authority as to what improvement must in the exiting system.

Definition : -

Ø  “Analysis of system is process of gathering fact, solution of problem and to decide overall constitution of the desired system. In system analysis we have to analyze all the processes, related features, required function, available sources and the time which should be specified for the analysis stage

Ø  The most important phase of developing any system is system analysis. Because of the analysis phase decides that type of requirements, materials, strangles and techniques, models are required.

Ø  All these things are depend upon our system that what type of our output of our system to function. We desire from the system is responsible for defining the above factors. So the overall structure of system that we want to implement will be decided in analysis part of a system development by analyst.

Preliminary Investigation

 Interviewing

The information is collected from system leader by interviewing to them a took suggesting from end user as per their requirement.

Ø   Visiting

For Clarification, Visited To Hari-Om Medical Store.

Ø   Questionnaires

By asking possible question to the system leader at the time of interview some questionnaires to collect the required information.

Feasibility Study - MEDICAL STORE INVENTORY AND BILLING MANAGEMENT SYSTEM

Technical feasibility

Customer the work for the system can be done with the present equipment and three is no need of other technologies so this application is technically feasible.

Economic feasibility

All software packages are available or already exist in the company and institute so this system is economically feasible.

Operation feasibility

Ø  System will be use immediate because all staff is aware of how to operate so there is no need to train them, so it is operationally feasible for the company and institute.

Ø  At the end of investigation it is found that this system is feasibly in all points of view.

Schedual feasibility

Ø  It is a measure of how reasonable the project timetable is 

Implementation feasibility

Ø  As far the Implementation is concerned, there would not be any problem. All the user of it gets its service by only operate this system.

                        Problem Analysis

Ø  We are asked some question for good requirement those are as follow :

·         What is the addition functionality you want in the system?

·         What are the problems you face in the existing system?

·         What are you expectation with the system?

·         How do you manage to do this work manually?

·         Is there anything else that wants to specify?

·         What the help of analysis we tried out to reduce the communication gap between the user and us.

System Development Strategies

Ø There are three distinct approaches to the development of any good system as the point of view system analysis and design.

· System development life cycle method.

· Structure analysis development method.

· System prototype method.

Ø Here, starting with 1st system development life cycle method. Which has the following activities of any system?

· Preliminary investigation.

· Determination of system requirement.

· Design of system.

· Development of software.

· System testing.

· Implementation and evolution.

Software Engineering Paradigm Applied - MEDICAL STORE INVENTORY AND BILLING MANAGEMENT SYSTEM

·         The waterfall model derivers its name due to the cascading effect from one phase to the other as is illustrated in above fig.

·         In this model each phase where define starting and ending point with identifiable deliveries to the next phase.

·         Note that this model is some time referred to as the linear sequential model or the software life cycle model.

Ø The waterfall diagram is basically divided into following 5 models.

• Requirement
• Design
• Implementation
• Verification
• Maintenance

Ø Requirement

• In the requirement phase the need to create the application is specified what is the need of the system is defined.
• What information to be feeder to create the application will come under the requirement phase?

Ø Design

• After the requirement phase the next phase is the design phase where the application is designed according the forms and other modules created.

Ø Implementation

          ·          Implementation is the process of having a system personnel phase check out and put new equipment into use, train user, install new application and construct  any file of data need to use it.

Ø Verification

• After the whole application is being developed the main phase is verification phase where the whole application tested and verifies to check the whole application

Ø Maintenance

• After the successful verification of the application the main phase is the maintenance where the application needs to be maintained for its successful operation in future.

Information Gathering

Ø  Information from field

·                      The main information of this system is gathering from the

Hari-Om Store,Visnagar.

·                      The error of this system are seen the studied. Because of this error we need necessary to develop.

·                      This type of system :

            ·          The system mainly develop for organize for remove the paper work.

            ·          Other detail are given to us from lecturer of our institute

Ø Information from books:

• The detail of designing of coding of this system are viewed from the “The complete reference of net programming book “, Master in VB.Net.

Data Dictionary 

BRIEF DESCRIPTION OF PROCESS - MEDICAL STORE INVENTORY AND BILLING MANAGEMENT SYSTEM

Proposed system includes updating of master file and generation of Reports. Using VB.NET as Front-end and Sql Server 2008 as Back-end. Detail of purposed system is as below.


Item Details:

This stores the information about the Item in the Medical store. Store the information such as Item code, Item name, stock,etc.


Purchase Details:

This keeps information about the purchase Item from dealer . This stores information such as dealer name, Item name, price , quantity etc.


Billing Details:

This keeps details of all billing information. This keeps records customer who purchase our item including customer name, bill no, and total amount.

Process Algorithm

· Step-1:- Start


· Step-2:- Login Process


· Step-3:- Check user name and password.


· Step-4:- If No then Back the Login process. If Yes then enter the main process.


· Step-5:-Check for the Item availability. If No then add dealer/Item entry. If Yes then sale and receive payment.


· Step-6:- Check for the dealer/Item identify. If No any dealer then add dealer entry and go to step-5;


· Step-7:- If return Item Yes then check bill no and return Item or payment. If No then Exit.


· Step-8:- Generate bill.


· Step-9:- Exit.






                                        

Testing - MEDICAL STORE INVENTORY AND BILLING MANAGEMENT SYSTEM

        

After the preparation of our project we used it with the help of hypothetical data. As the requirement was satisfied with these data, we implemented the project on the original data.

The system though developed carefully, whenever it is taken in actual use may generate errors. So the main purpose of testing is to remove such type of runtime error and correct them. The scope of the system test includes both manual operation and computerized operations. We performed various system tests such as program test, string test, and system test.

Program test:
These are designed to test the logic of program. Under this testing, the individual forms were considered as a program and verification was done by entering hypothetical as well as original data.

System test:

These are used to test all programs which together constitute the system consisted of various forms. All forms are liked with each other perfectly and make our system a perfect one.

Post Implementation Review

The review about post implementation from them is completely satisfactory. They are pleased with our services and our nature. We followed the rules of there school. We plan out our system according to their conve

Further Enhancement

In the system you can get the reports which includes bills,customers information. In the bills we can know the item information and also stock information.

Since modular and structure approach has been taken towards development of system, it can also expand other functions of the part of organization. It also very useful for the management. With the used of these system user can easily update the record, view the record and quickly generate the report.nience. They were totally satisfied and pleased with our system. They haven’t any problem regarding our project work.