Medical Shop Report Final.docx

Department Of Computer Science. K.K.Wagh Arts, Commerce, Science and Computer Science College. Nashik-422003 Academic Year2015-2016

“Medical Distributer Management System” SUBMITED BY 1.

Mr.Nikhil Nikam.

2.

Mr.Melvin Anthony.

1

Karmaveer Kakasaheb Wagh Education Society’s K. K. Wagh Arts Commerce, Science, & Computer Science College Saraswati Nagar Nashik-422003

CERTIFICATE This is to certify that, Mr.NIKAM NIKHIL RAVINDRA. Mr. PALAKKAL MELVIN ANTHONY. Have satisfactory completed their project MEDICAL DISTRIBUTER MANAGEMENT SYSTEM as fulfillment in T.Y.B.C.A. Class for the academic year 2015-2016.

Project Done by: Mr.NIKAM NIKHIL RAVINDRA. Mr. PALAKKAL MELVIN ANTHONY.

Prof. Smita Wagh.

Prof.V.V.Gosavi ( H.O.D.)

Projecct Guide

Internal Examiner

External Examiner 2

ACKNOWLEDGEMENT We own our sincere gratitude to all those people who have given us their constant support and encouragement without which our project report would not have reached this stage.

We would like to express our gratitude to Dr.V.M.Sewlikar, Principal, K.K.Wagh Arts, commerce, science and Computer Science College. And Prof.Smita Wagh, Our Project guide for the support and the infrastructure they have provide, so that we could successfully complete the project on time. Last but not the least we would like to express our sincere thanks to all staff members and our friends for their help and cooperation in all phases of the project.

1.

Mr.Nikhil Nikam.

2.

Mr.Melvin Anthony.

3

INDEX Sr. No.

Topic

Page No.

1

Acknowledgement

3

2

Problem Definition

7

3

Existing System And Need Of New System

7

4

Scope of The work

10

5

Feasibility Study(Including H/W & S/W Setup Requirement)

11

6

Requirement Analysis(Including fact finding method)

11

7

E-R Diagram

13

8

Normalized Database Design & Data Dictionary

14

9

Data Flow Diagram(DFD)

19

10

Input Output Screen Using Sample Data Reports

30

11

Drawback, Limitation &Proposed Enhancement

21

13

Bibliography

45 4

1. INTRODUCTION

1.1

MEDICAL SHOP INTRODUCTION The main purpose of medical agency is to ensure a continuous

supply of good quality pharmaceutical, X-rays, laboratory surgical and other related medical supply product for public use to medical retail stores. Cost effective procurement through adequate and efficient distribution to different areas.

Medicine in the medical store is used as preventive

measures for our lives. The medical agency has collection of various types of medicine which is produced by the companies. A medical agency also proves to be prominent for retailers as all kinds of medicine are available at a place and a right time. So I have developed a complete application which reduces the maintenance burden, and enhances performance of a medical agency in all aspects with the higher accuracy. It deals with automating the tasks of maintaining and transacting the medicines. It includes the activities such as maintenance of purchase, stock, and sales details, maintain distributor information, medicine information, billing and generating reports.

5

1.2

EXISTING SYSTEM AND NEED OF SYSTEM The working of a medical agency is obtained by visiting the actual

medical agency, talking to the person working there. It is provided here for completeness of a case study. In medical agency, the retailers come gives the purchase order to the owner/person working there. Owner searches for the given medicine, gives the required medicine to the retailers and generates the bill as per the requirement. Then the bill is given to retailers, retailers pay the bill and receipt of the bill is given to him. At the end of the day, owner goes through the bill, medicine and the stock, verifies all the selling details and also checks the expire date of the medicine available. If necessary, gives the purchase order to company for the required medicines, in return company gives the medicine to the owner for the payment. Then owner pays the bill to company. Then the owner updated all the purchase details and selling details, all this done manually by maintaining register. 1.2.1 PROBLEM WITH PRESENT SYSTEM 1) Present working of the medical stores is manual. 2) Date of purchase and selling of medicine is maintained in many registers so data accuracy is minimum. 3) Process of manual filling of purchase, selling and billing details is time consuming. 4) Lost of any page in the register makes availability of information slow and also loss of any document is possibly. 6

5) Record searching is time consuming and slow. 6) Billing details and purchase order details is time consuming and also the calculation is done manually. By computerization of the existing system, above drawbacks can be eliminated and best result can be achieved.

1.3

ADVANTAGES OF COMPUTERIZATION The main advantages of computerizing the activities of business

organization are as follows: 1) Speed: Computerisation helps in processing the data placed in several data files in no time. This is possible due to the high speed of computers for processing data and CPU of the computer works at the speed of electricity which is the highest ever attainable speed. 2) Accuracy: The data processed by the computer are highly accurate. The programs written on the system checks and controls data before and during processing. It detects invalid data and ensures high degree of accuracy and reliability of output reports. 3) Flexibility: The modern digital computers can be used for a variety of purposes. E.g. online processing, multiprogramming etc. 4) Choice of Configuration: Wide ranges of peripherals are available for many computer systems, which allow business organization to select those which most suit its processing requirements. 5) Storage capacity: Large volumes of data can be conveniently stored, accessed and altered.

7

6) Management information: They can be used to provide useful information of management for control and decision making. 7) Data Processing: Computer has lifted the heavy data processing constraint with the manual system and has opened up new avenues for planning, control and data experimentation. 8) Volume: Computers can store volumes of data and can retrieve the desired information quickly. This is very useful in the areas like insurance, bank accounts etc where large number of documents is handled every day. 9) Database: Computer facilities the establishment of database. Such a database integrates data records and reduces data redundancy. 10)

Reduction in paper work: The use of computers for data processing has

helped the management of business organizations to cope with increasing problem of paper handling. The computers have speeded up the process and have eliminated the paper needs through the storage of data in elaborately constructed data bases and files. 11)

Reduced cost: Though the initial investment for installing a computer is

high, but it substantially reduces the cost of each of its transaction. Cost reduction occurs due to processing of huge data and record keeping. 12)

Facilitates report preparation: Computer facilitates the preparation of

various types of reports required by organizational executives for the purpose of decision making and control. 13)

Reduce the space requirements: The use of computer for office

activities reduces the requirements of office space which otherwise is required.

8

14)

Reduces the manpower requirement: The number of persons required

for performing various organizational activities will be reduced by using a computer system. 15)

Increased ability to perform computations: Computers perform

computations with a very high speed. 16)

Diligence: Being a machine, it does not suffer from boredom, tiredness

or lack of concentration, even if millions of computations are to be performed by a computer. It performs the calculations with same accuracy and speed. 1.3 SCOPE OF SYSTEM. 1) Large volume of data can be handled by the system. 2) Various reports will be provided by the system. 3) Security and integrity of database can be maintained. 4) Information unavailability due to loss of records is eliminated. 5) Payment, calculation of customer’s bill and supplier’s bill is easy and fast. 6) Efficient working of medical stores can be maintained. 7) Keeping records in details of each purchase, selling and billing is possibly. 8) Proper management of all the medicine can be maintained. 2. FEASIBILITY STUDY System analysis has to examine whether the developed computerized medical management system is feasible from the point of view of operational, technical and economical. System analyst has to also consider the feasibility factor at the time of analyzing of the system. The study of the following points will prove if the proposed system is feasible or not. 9

2.1 TECHNICAL FEASIBILITY A Computerized system will be technically more effective than the existing manual system. The person who is presently handling manual system is going to handle the computerized Medical Management System. The software system may be easy to understand and to use because this is as per the user requirement. The software system produce report as per the requirement of the end user. 2.1.1 Hardware Requirements 1.

Intel Pentium IV (or higher)

2.

1 GB RAM

3.

40 GB Hard Disk

4.

Printer

5.

DVD - ROM

2.1.2 Software Requirements 1.

O.S. – Windows 7.

2.

Microsoft Access 2007.

(B). ECONOMICAL FEASIBILITY Economical feasibility study analysis is most frequently used for evaluating the effectiveness of a proposed system. The procedure is to determine the benefits and saving that are expected from a proposed system and compare them with input costs. The benefits may not be in the form of

10

speed only but also in error handing redundancy control, availability of online information and reduction cost for stationary users. (C). OPERATIONAL FEASIBILITY Operational feasibility study addresses question whether we can run the proposed system with minimum hardware software setup and the demands of processing are realistic. Since this system is being developed for the medical management, every user will undergo training use of the software system. The system will provide timely information and status of various activities to manage, to facilitate the user of the system

11

3. ANALYSIS AND DESIGN ER Diagram:

Cname User-id

address

cno

Password

e e

Customer

Admin/Owner

place

Total cost

Select

maintains

Prod_name

Prod_no

Total item

Qty

Has

Order

Medical Product

Has o

o Path

To

Company

sname

s id

Image

Has

Expiry Type

address

Information

Supplier

12

Class Diagram:

1

Medical Product

Bill

Prod-id: no.

Total cost: double

Name: String

Total item: int

Price :double

Additem():void

Licence type:string

1….*

1

Get image(): void

1 RemoveItem():void UpdateTotal():double

Getspec(): void 1 1

0….*

0…..*

Specification

Item stock

Spec-id: string

Prod-id: number

Model: string

Qty: int

Type: string

Price: double

components: string

TotalCost:double UpdateQty():void

13

Use Case diagram:

Personal Details



Medical Product

Medical Product Details

Details

Sales Order Info

Company Details

PO Detail Payment Info

Login Detail

View Product



View Reports

14

<Supplier>

Sequence Diagram:

Medical Agency

User

Check Request

Visit Dis play

Process Request

Send O/P Check Login

Login Display output

Send Output

Order Product Accept Detail

Select product

Give payment info

DataBase

Accept Payment info Dis play order detail

Display total bill & item

15

Check Process

Activity Diagram (Admin, User):

16

Start

Master Maintance

Validate User

Add Product

Order Detail

Event Detail

Payment Info

Exit

17

Start

Daily visit

Registers

Verified By Admin

Purchased

Buy Medical Product

Display Output

Exit

18

Data Flow Diagram(DFD)

19

20

21

3.1

MAJOR MODULES 1) Distributor Management 2) Purchase Management 3) Sales Management 22

4) Stock Information Management 5) Medicine Transaction Management 6) Reporting Tools 7) Search Facility

3.2

FEATURE LIST 1) Complete transaction & maintenance of the medicine, purchase & stock information. 2) Full automation of distributor, sales. 3) Billing & generating reports of all the transaction. 4) Back Up facility. 5) Most robust & reliable system. 6) Advanced database management system.

6. Table Design 5.1STRUCTURE OF CUSTOMER TABLE Sr No.

Field Name

Field Type

Field Size

Description

1.

CID

Number

Long Integer

Customer_id

PK

2.

C_Name

Text

50

Customer name

-

3.

C_Addr

Text

50

Customer add

4.

Pincode

Number

Long Integer

Customer Pin

-

5.

Contact No

Number

Long Integer

Customer phone

-

6.

License No

Text

50

23

CustomerLicNo

key

-

-

5.2 STRUCTURE OF SUPPLIER TABLE Sr No.

Field Name

Field Type

Field Size

Description

Key

1.

s_num

Number

Long Integer

Supplier _id

PK

2.

s_name

Text

50

Supplier name

-

3.

s_addr

Text

50

Supplier add

4.

s_phone

Number

Double

-

Supplier phone

-

5.3 STRUCTURE OF MANUFACTURER TABLE Sr No.

Field Name

Field Type

Field Size

Description

1.

MID

Number

Long Integer

Supplier _id

PK

2.

MName

Text

50

Supplier name

-

3.

Address

Text

50

Supplier add

4.

Phone

Number

Double

5.

Contact No

Number

Long Integer

5.4 STRUCTURE OF MEDICINE TABLE

24

key

-

Supplier phone

-

Supplier No

-

Sr no.

Field Name

Field Type

Field Size

Description

1.

med_num

Number

Long Integer

Supplier _id

2.

Med_name

Text

50

Supplier name

3.

Batch_num

Number

Long Integer

Supplier add

4.

Man_date

Date/Time

Short Date

5.

Exp_date

Date/Time

Short Date

6.

Med_quantity

Number

Long Integer

7.

Med_price

Number

Long Integer

8.

S_num

Number

Long Integer

9.

I_num

Number

Long Integer

10.

M_num

Number

Long Integer

Supplier phone

5.5 STRUCTURE OF INVOICE TABLE Sr No.

Field Name

Field Type

25

Field Size

Key

Key PK -

1.

I_num

Number

Long Integer

PK

2.

Si_num

Number

Long Integer

-

3.

Med_num

Number

Long Integer

4.

S_num

Number

Long Integer

5.

Quantity

Number

Long Integer

6.

pono

Number

Long Integer

-

5.6 STRUCTURE OF PODETAIL TABLE Sr No.

Field Name

Field Type

Field Size

1.

P_num

Number

Long Integer

2.

med_num

Number

Long Integer

3.

quantity

Number

Long Integer

4.

pono

Number

Long Integer

26

-

5.7 STRUCTURE OF PURCHASEMASTER TABLE Sr No.

Field Name

Field Type

Field Size

1.

Pur_num

Number

Long Integer

2.

S_num

Number

Long Integer

3.

paymode

Text

50

4.

total

Number

Long Integer

5.8 STRUCTURE OF PURCHASEORDER TABLE Sr No.

Field Name

Field Type

Field Size

1.

pono

Number

Long Integer

2.

po_date

Date/Time

Short Date

3.

reciept_date

Date/Time

Short Date

4.

paymode

Text

50

5.

Pur_num

Number

Long Integer

27

5.9 STRUCTURE OF PURCHASERETURN TABLE Sr No.

Field Name

Field Type

Field Size

1.

Pr_num

Number

Long Integer

2.

med_num

Number

Long Integer

3.

quantity

Number

Long Integer

4.

reason

Text

50

5.10 STRUCTURE OF SALES TABLE Sr No.

Field Name

Field Type

Field Size

1.

s_num

Number

Long Integer

2.

med_num

Number

Long Integer

3.

quantity

Number

Long Integer

4.

Sm_num

Number

Long Integer

28

5.11 STRUCTURE OF SALESMASTER TABLE Sr No.

Field Name

Field Type

Field Size

1.

Sm_num

Number

Long Integer

2.

C_num

Number

Long Integer

3.

Pay_mode

Text

50

4.

total

Number

Long Integer

5.

Date1

Date/Time

Short Date

5.12 STRUCTURE OF SALESRETURN TABLE Sr No.

Field Name

Field Type

Field Size

1.

Sr_num

Number

Long Integer

2.

s_num

Number

Long Integer

3.

Med_num

Number

Long Integer

29

4.

quantity

Number

Long Integer

5.

Rate

Number

Long Integer

6.

Reason

Text

50

Screen Shoots

30

1.Login Screen:

31

2.Main Menu:

Customer Entry: 32

Transaction Delivery Challan (Invoice): 33

Return Goods:

ORDER

34

Purchase Order:

Sales Order:

35

Reports

36

1. Bill Reports:

37

2. Customer List Reports:

Current Stock List:

38

Expired Medicine Report:

39

40

Product List Reports:

41

Manufacturer List Report:

User Maintenance:

42

Component Diagram:

43

Medical Mgt System

.CS files

Sql

.Dll/ User control

Deployment Diagram:

MSAcces Databas s eservice s

.Net Framework

Windows 7 Professional

Bibliography

44

45