Case study by:-
MR. Tushar S Kapare (45).
MR. Akshay A Gadkari (40).
MR. Harshad V Devrukhkar (27).
Guided By:-
Mrs. Rupali Patil
PRAGATI COLLEGE OF
ARTS, COMMERCE AND SCIENCE
F.Y/ S.Y/ T.Y B.SC (IT)
CERTIFICATE
This is to certify that Mr.Tushar S Kapare (Roll no. 45) &
Mr. Akshay A Gadkari (Roll no. 40) & Mr. Harshad V Devrukhkar
(Roll no. 27) from S.Y B.SC (IT) have successfully completed the case study
entitled as Medical shop management system under the guidance of Mrs.
Rupali Patil during the academic year 2009-10.
Date:-
Professor-In-Charge
Mrs. Rupali Patil
2
INDEX
S. No . Topic Page No.
1. Overview 6
2. Current System 6
3. Limitations of current system 7
4. Proposed System 7
5. ER-Diagram 10
6. DFDs 11
7. System Flowchart 17
8. Structured Chart 18
9. Gantt Chart 19
10. Menu Tree 20
11. Form Layout 21
12. Table Listing 22
13. Report Listing 24
14. References 25
15. Conclusion 26
3
ACKNOWLEDGEMENT
We are very delighted to take the opportunity of introducing our case study entitled
“Medical shop management system”.
We would like to take opportunity to acknowledge the innumerable guidance & support
extended to us by our guide, ‘Mrs. Rupali Patil’ in preparation of this case study.
4
Medical shop Management system
Overview:-
It is the complete medical shop management software is so designed as to ease the work load of
medical shop professionals. The main feature includes invoicing, inventory and stock control,
accounting, client and vendor management.
This software helps you to track all the profits, loss, profitable clients and products of medical
shop moreover it’s a medical shop accounting software. Flexible and adaptive software suited to
medical shops or stores or pharmacies of any size.
Current system Features:-
Menu driven, Key board and mouse navigation
Paperless practice
Improve efficiency, productivity
Cost effective solutions
Graphical User Interface with Context Sensitive Help
Automatic importing of drug list
Inbuilt account group and account ledgers
Option for setting default company
Keep address book / telephone directory for easy access
Option for setting default company
5
Limitations of current system:-
We can’t view a financial report of past financial year
We can’t created multiple companies with different financial year
Not maintain all financial report and financial statements such as day book, profit and
loss amount and balance sheet
It allows only one user therefore it is not provide a high security
Not have a better search option for finding available product of company
It provide only 50 reports
Special training needed for using the system
Accounting knowledge is must for use this system
Proposed system:-
It is the complete medical shop management software is so designed as to ease the work load
of medical shop professionals. The main feature includes invoicing, inventory and stock control,
accounting, client and vendor management.
This software helps you to track all the profits, loss, profitable clients and products of medical
shop moreover it’s a medical shop accounting software. Flexible and adaptive software suited to
medical shops or stores or pharmacies of any size.
This System will store the information of medicines & customers in the system. It will also
store the information about stock details. This system provides security by granting access rights for
changing the sensitive data to administrator only. Customized search options are also available in this
system. This system can generate all kinds of reports as per the user’s requirements.
6
Proposed system feature:-
Multiple companies with different financial year can be created
We can view report of past financial year
Back up and restore facility
Keep record of daily customers
Keep records of salesmen
Tracking sales done by a particular salesman
Manage counter sale
Keep track of instant collecting medicines from near by medical shop and selling directly
Reminders for product low stock, product short expiry
Keeps track of all payment , receipt of company
Creating different users with different privilege level for providing high security
Handle financial accounting.
Provides around 100 reports with maximum filtering option
Better search option for finding available products of company
Search can be filtered by product group, product, shelf,
Manufacture etc
Record various events of day which can be viewed as event calendar
7
System Requirements:-
• Required processor :Pentium 90 MHz or faster
• Required RAM :128 MB (256 or more recommended)
• 25 MB of available hard-disk space for installation
• CD-ROM drive (only for installation)
• 1,024x768 display (1,280x800 recommended)
Software Specification:-
• Operating system: .Net framework 2.0 version compactable software platform
• Technology: Microsoft .net 2005
• Front end: C#.NET
• Back end: Microsoft SQL Server 2005
ER-diagram:-
8
9
Context level diagram:-
10
Context analysis diagram:-
11
LOGICAL DFD:-
12
DFD FRAGMENTATION:-
First level DFD:-
13
Second level DFD :-
14
Third level DFD:-
System flow chart:-
15
16
STRUCTURE CHART:-
17
Gantt Chart – Project Schedule:-
18
Menu tree:-
Form layout:-
19
Table layout:-
20
Product:-
Column name data type
P_id int
P_name varchar (50)
P_gen_name varchar (50)
P_quality float
P_price int
Column name data type
D_id int
Dealer:-
D_name varchar (50)
Bill float
Quantity int
Date int
21
Pharmacist:-
Column name Data type
Phar_name Varchar(50)
Phar_id int
Phar_cont_no int
timing int
Date of joining int
Company:-
22
Column name Data type
Comp_id int
Comp_name Varchar(50)
Customer:-
Column name Data type
Cust_name Varchar(30)
Cust_ID int
23
Report Listing:-
24
Reference:-
www.projectguidance.com
http://e-library.net/
www.sourcecodeonline.com
www.developers.net
www.codeproject.com
25
Conclusion:-
It is the complete medical shop management
software is so designed as to ease the work load of medical
shop professionals. The main feature includes invoicing,
inventory and stock control, accounting, client and vendor
management.
26
