Transcript Document

Index
Introduction
Acknowledgment
Preface
Introduction to VB
Introduction to Oracle
Client Server Model
What is RDBMS
Data Flow Diagram
Data Dictionary
Tables
Forms
Reports
Chart
Module
Configurations
Conclusion
Introduction
 Project Name : Medical Store Management System
 Project Type : Medical Store Management
 Team Members : 1 Ranpariya Pramod .C.
2 Panaliya Vijay .V.
 Client Introduction : Kishan Medical Store Gondal
Sukrupa Medical Store Rajkot
Acknowledgment
On the Successful Completion of Project we would especially like to thanks
Mr. Janual Sir for giving us through out the project guidance and for his constant
support and help in design and implementation of this project.
We are also thankful to Anand Madam and Hetal Madam for this
encouragement and exclusive guidance,without which we would have been lacking
something.
We are grateful to Mr.Kamaljit sir and Mr.Krunal sir,Shree M. & N.Virani
Science College,for all the facilities they provide us thought out our academic and for
encouraging us to take us the activity. We would also like to Mr.Ravi sir and Vaishali
Madam for this encouragement and the rest of faculties and staff members of Shree M.
& N. Virani Science College their cooperation.
Moreover we would also like to thank our friends and peers and last but not
least we are grateful to our parents and our HHH group for support and unconditional
help which made our project a real success.
Thanking You,
Ranpariya Pramod .C.
Panaliya Vijay .V.
Preface

Computer technology has provided beneficial in many ways,from visible ,spectacular
to routine. Now a day there may not be any place where the computer will not be there to
help the great human being. Computer has made the routine work so easy,comfortable and
fast that it has totally changed the life of the common human being.
Our software is developed for a routine Medical Store Work. A few years back the
work of these kinds of Medical Store Was not only manual but also time and lots of labor
work consuming.
The routine Medical Store on paper transaction may raise many problems like large
and bulky economic as well as user database.
Advantages of this software : 1 Easy and Fast routine work
2 Search for particular user choice becomes so fast and accurate that attracts the
users.
3 Reduce the work burden in easy and most accurate way
Moreover the system can also generate customized reports on various conditions for
keepings the track of currents as well as past records.
This system is capable of handling the large database better and can display past
information’s or transactions done with different people as well done with the different items
then manual systems.
Introduction to VB
 Visual Basic comes in three flavors :


(1) The Visual Basic Learning Edition
(2) The Visual Basic Professional Edition
(3) The Visual Basic Enterprise Edition
The Visual Learning Edition
It is the introductory edition that lets you easily create Windows
applications.
The Visual Basic Professional Edition
This edition is for the computer professionals and includes advanced
features such as tools to develop ActiveX and Internet controls.
The Visual Basic Enterprise Edition
This is the most advanced edition and is aimed to programmers who build
distributed applications in a team environment.
Introduction to Oracle
Oracle is the most widely used database in the world. It runs virtually kind of
computer , from PCs and Macintoshes.
To minicomputers and giant mainframes. It virtually identically on all these
machines, so fact makes knowledgeable ORACLE users and developed very much in
demand, and makes your ORACLE knowledge and skills very portable.
Every business enterprise maintains large volumes of data for its operations.
With more people accessing this data for their work the need to maintain its integrity
and relevance increase. Normally , with the traditional methods and validity are very
high.
Oracle is the most widely used database in the world. It runs virtually every
kind of computer, from PCs and Macintoshes,to minicomputers and giant mainframes.
It functions virtually identically on all these machines,so that when you learn it on
one, you can use it on any other.
Oracle 8 is an Object Oriented Management System (ORDBMS).It offers
capabilities of both relational and object – oriented database systems.In general
objection can be defined as reusable software codes, which are location independent
and specific task on any application environment with little Or no change to code.
Client – Server Model
Client Server architecture is a process involving a minimum of two
independent entities ,one is client and the other is the server. The client
makes a request to the server and the sever services the requests and the
resulting data is sent to the client,in this application .
Server services the requests and the resulting data is sent to the client.
In this application,two separate applications operating independently could
work together to complete a task.
Designing an efficient client/server application is some – what of
balancing act,the goal of which is to evenly distribute execution of tasks
among processors while making optimal use of Available resources. Given
the increased complexity and processing power required to manage a
graphical user interface (GUI) and the increased demands for throughput on
database servers and networks , achieving the proper distribution of tasks is
challenging.
What Is RDBMS ?
A Relational database is a database structured on the relational model. A
Relational Database Management System or RDBMS is a suite of software
programs that can be used for crating,maintaining,modifying and manipulating a
relational database. It can also be used to create the application that a user will for
interacting with the data stored within the database. Three important factors in
any RDBMS exist are..
Base Tables : A base table is a table with a name that physically exists in a
database. It is a created by the user. A base table can be created ,altered and
removed from a database. All these tasks are accomplished using SQL (Structured
Query Language) statement.
Query Results : When a ‘question’ is asked to a table ,the resultant data
can be displayed from data stored in tables. Such tables are called query results.
Views : A view is virtual table. Some columns of a base table may not be
required by the user. In such cases, a view is created. This view will consist only
those columns of the base table that the user is interested in seeing. This format
can be saved as view by giving it a name
Data Flow Diagram
Doctor Master
Patient Master
Purchase Bill Details
Company Master
Sales Bill Details
Item Master
Dealer Master
Data Dictionary
Tables
Master Tables
Transaction Tables
Master Tables
Login Master
Doctor Master
Patient Master
Company Master
Item Master
Dealer Master
Login Master
Serial No
Fieldnames
Data Type
Fields Size
Description
Constraint
Unique
1
Login_Id
Varchar2
20
Id of User
2
Password
Varchar2
20
User Password
Doctor Master
Serial No
Fieldnames
Data Type
Fields Size
Description
Constraint
Unique
1
Doctor_Id
Number
10
Id Number
2
Doctor_Name
Varchar2
20
Name of Number
3
Degree
Varchar2
25
Degree of Doctor
4
Address
Varchar2
50
Add of Doctor
5
Phone No
Number
12
Ph_no of Doctor
Patient Master
Serial No
Fieldnames
Data Type
Fields Size
Description
Constraint
Unique
1
Sales_Bill_No
Varchar2
10
Bill No
2
Patient_Name
Varchar2
20
Name of Patient
3
City
Varchar2
15
City of Patient
4
Doctor_Name
Varchar2
20
Name of Doctor
5
Sales_Date
Date
--
Date of Sales
Company Master
Serial No
Fieldnames
Data Type
Fields Size
Description
Constraint
Primary key
1
Mfg_Id
Number
10
Id_no of Mfg
2
Mfg_Name
varchar2
20
Name Of Mfg
3
Address
varchar2
50
Address of Mfg
4
City
Varchar2
15
City of Mfg
5
Phone_No
Number
12
Phone No of Mfg
6
Email_Id
varchar2
30
Email Id of Mfg
Item Master
Serial No
Fieldnames
Data Type
Fields Size
Description
1
Item_Id
Varchar2
10
Item_Id
2
Item_Name
Varchar2
20
Item_Name
3
Qty
Number
15
Qty of Item
4
Type
Varchar2
20
Type of Item
5
Pack
Number
20
Pack of Item
6
Price
Varchar2
10,2
Price of Item
7
Mfg_Id
Number
10
Id of Mfg
8
Mfg_Date
Date
--
Date of Mfg
9
Exp_Date
Date
--
Date of Exp
10
Batch_No
Varchar2
20
Batch No of Item
Constraint
Primary Key
References
(Comp_Mast)
Dealer Master
Serial No
Fieldnames
Data Type
Fields Size
Description
1
Dealer_Id
Varchar2
10
Id of Dealer
2
Dealer Name
Varchar2
20
Name of Dealer
3
Address
Varchar2
50
Address of Dealer
4
City
Varchar2
15
City of Dealer
5
Pin code
Number
10
Pin code of Dealer
6
Mobile_No
Number
12
M_no of Dealer
7
E-Mail_Id
Varchar2
30
Dealer E-Mail Id
Constraint
Unique
Transaction Tables
Purchase Bill Details
Sales Bill Details
Purchase Bill Details
Serial No
Fieldnames
Data Type
Fields Size
Description
1
Sr_no
Number
10
Sr of Item
2
P_Date
Date
--
Date Purchase
3
Item_Name
Varchar2
20
Name of Item
4
Item_Id
Varchar2
10
Id of Item
5
Pack
Varchar2
20
Pack of Item
6
Mfg_Name
Number
15
Name of Mfg
7
Type
Varchar2
15
Type Item
8
Qty
Number
15
Qty of Item
9
Price
Number
10,2
Price of Item
10
Mfg_Date
Date
--
Date of Mfg
11
Exp_Date
Date
--
Exp of Mfg
12
Total_Amount
Number
10,2
Total Amt
Constraint
Sales Bill Details
Serial No
Fieldnames
Data Type
Fields Size
Description
1
Sales_Bill_No
Varchar2
10
Bill_No of Sales
2
Sales_Date
Date
--
Date of Sales
3
Qty
Number
10
Qty_Item
4
Item_Name
Varchar2
20
Name of Item
5
Pack
Varchar2
20
Packing
6
Mfg _Name
Varchar2
20
Name of Mfg
7
Batch_No
Varchar2
20
Batch
8
Exp_date
Date
--
Exp_date_Item
9
Price
Number
10,2
Price of Item
10
Total_Amount
Number
10,2
Amount_Sales
11
Doctor_Name
Varchar2
10
Name of Doctor
12
Patient_Name
Varchar2
20
Name of Patient
13
City
Varchar2
15
City_of Patient
Constraint
Forms
Splash Screen
Login
Login Master
Doctor Master
Patient Master
Company Master
Item Master
Dealer Master
Purchase Bill Details
Sales Bill Details
Stock Details
Splash Screen
This is Starting of Project ,see the Splash Screen
Login
Project Connected to Oracle Successful then You can See the Your
Login Form
Login Master
If Login Id is Administrator, So You Can Create New User Or Any
Changes For User
Doctor Master
Here is the form for entering the details of different Doctors
Patient Master
Here is the form for entering the details of different Patients ,But not
enter Here Patient details Because Sales Bill Details entering already
Created Data in this form
Company Master
Here is the form for entering the details of different Company
Item Master
Here is the form for entering the details of different Item ,But not
enter the Item Details Because Purchase Bill Details entering already
Created Data in this form
Dealer Master
Here is the form for entering the details of different Dealer
Purchase Bill Details
Here is the form for entering the details of different Purchase Item
,Please Truly enter Data Because This Data created in Item Master,
and If You Press New Button, Sr. No Auto Increment.
Sales Bill Details
Here is the form for entering the details of different Sales Item
,Please Truly enter Data Because This Data created in Patient Master
,and If You Press New Button, Sales Bill No Auto Increment.
Stock Details
Here,You Can See the How Many Item From Item Master.Drop
Down Combo Then Select Item Name,Pack,Type ,and Press Stock
Button Then You can see Massage Box for “Stock Available”.
Reports
Doctor Details
Patient Details
Company Details
Dealer Details
Purchase Bill Details
Sales Bill Details
Stock Details
Doctor Details
Patient Details
Company Details
Dealer Details
Purchase Bill Details
Sales Bill Details
Stock Details
Chart
Module
Public cn As New ADODB.Connection
Public rs As New ADODB.Recordset
Public flag As Integer
Public Sub main()
On Error GoTo er:
cn.Provider = "MSDAORA.1;data source = atmiya"
cn.Open , "dca05030", "dca05030"
rs.Open "select * from Login_Master", cn, adOpenStatic,
adLockReadOnly
MsgBox "Open Project in Medical Successfull connected"
Exit Sub
er:
End Sub
Configurations
Operating System : - Window 98 or Window Xp Professional
Hardware : -
Processor :
RAM :
Hard Disk :
Monitor :
Celeron D or P – IIII
128 MB or 256 MB
80 GB Capacity
Color Monitor
Software : -
Client (front end) : Visual Basic 6.0
Server (back end) : Oracle 8.0
Conclusion
This Project has been a great experience for us to learn so
many things from noting. We have gained an insight into the working of
the project of Medical-Store, which made us to face the real situation of
the real life.
Initially which we were given the project we were told that “ No
live demo of this project available in Rajkot. So all the works will have to
be completed by you. “ So in the beginning we faced many problems to
complete this project but with the help of our faculties we could
complete this project in nice and easy way.
This project has really changed our way of the thinking about
the real world and now we are ready to face such kind of problems in
nice and easy way.