MICROPROJECT REPORT

ON
"Medical Store Management System"

Submitted by

Shweta Bhargude (56)

Neha Pawar (34)
Under Guidance of

Prf. Jyoti Mante

Diploma in Computer Engineering
(As per directives of I Scheme, Msbte)

MIT Polytechnic Pune - 411058

ACADEMIC YEAR :- 2021-22

 MAHARASHTRA STATE

BOARD OF TECHNICAL EDUCATION

Certificate
This is to certify that Mr./Ms. Neha Pawar Roll No: 34 of V Semester of Diploma in
Computer Engineering of Institute: MIT Polytechnic Pune (Code:0148) has completed the
Micro Project satisfactorily in Subject: Software Testing(22518) for the academic year 2020-
21 as prescribed in the curriculum.

Place: Pune Enrollment No: 1901480142

Exam. Seat No: —

Subject Teacher Head of the Department Principal

2
 MAHARASHTRA STATE

BOARD OF TECHNICAL EDUCATION

Certificate
This is to certify that Mr./Ms. Shweta Bhargude Roll No: 56 of V Semester of Diploma in
Computer Engineering of Institute: MIT Polytechnic Pune (Code:0148) has completed the
Micro Project satisfactorily in Subject: Software Testing (22518) for the academic year 2020-
21 as prescribed in the curriculum.

Place, Pune Enrollment No: 1901480165

Date: Exam. Seat No: —

Subject Teacher Head of the Department Principal

MAHARASHTRA STATE BOARD OF TECHNICAL
EDUCATION
 INDEX
SR NO CONTENTS PAGE NO

1 Rationale 3
2 Aim of the Micro-Proj ect 3
3 Course Outcomes Addressed 3
4 Literature Review 3
5 Actual Methodology Followed 7

6 System Testing 8
7 Actual Resources Used 10

8 Skills Developed 10
9 Applications of Micro Project 10
 Annexure - I

Part A - Micro-Project Proposal

"Medical store management system"

1.0 Aim of the Micro-Project -

The aim of Microproject is to prepare report on Medical store management system.

2.0 Intended Course Outcomes -

b) Prepare the test cases for different types and levels of testing,

3.0 Proposed methodology -

The project aims is to is to prepare report on Medical store management system in
the following format:

step 1 :- Searched and Selected the topic for micro project.

step 11 :- Discussed about the microproject.
step 11 Distributed the work accordingly.
step 111 Collected and gathered the required data.
step IV Prepared the test cases.
step V We Process information in one document step
VI We Consulted with our subject teacher.

4.0 Action Plan

Name of responsible
Planned Planned Team members
Sr.
No. Details of Activity Start Date Finish Date

Searched and selected the topic Neha Pawar

1 Shweat Bhargude
for microproject. 02/10/2021 08/10/2021

Discussed about the micro Neha Pawar

2 project. 09/10/2021 15/10/2021 Shweat Bhargude
 Neha Pawar
3 Distributed the work accordingly. 16/10/2021 22/10/2021 Shweat Bhargude

4 Collected and gathered the Neha Pawar

required data, 23/10/2021 30/10/2021 Shweat Bhargude
5 Create the data flow diagram 03/11/2021 09/11/2021 Neha Pawar
(DFD) Shweta Bhargude

6 Study the working of Model used 10/11/2021 16/11/2021 Neha Pawar

in microproject. Shweta Bhargude

7 22/11/2021 24/11/2021 Neha Pawar

Study various testing levels. Shweta Bhargude

8 Prepared the test cases for 27/11/2021 29/11 /2021 Neha Pawar
selected microproject. Shweta Bhargude

Neha Pawar
9 Analyze the report and make 06/12/2021 12/12/2021
Shweta Bhargude
changes if required.
Neha Pawar
Edited and prepared the final Shweta Bhargude
10 14/12/2021 21/12/2021
report.

5.0 Resources Required -

Sr.
Name of Resource Specifications
No.
1 Computer system Processor i 7 RAM-8GB

2 Operating System Windows 10

3 Software Microsoft word, Microsoft Excel

Team Members
Roll No. Name
Neha Pawar
34

56 Shweta Bhargude
 Annexure — Il

Micro-Project Report

"Medical store management svstem"

6.0 Rationale —
Medical shop management requires user entry of container and product dimensions,
together with information on weight and orientation constraints. It implements the
storage and retrieval system of day-to-day activities which Involves daily
transaction report, monthly wise report on goods delivered, enquires which enables
us to provide efficient and accurate methods of organizing and accessmg different
types of informatiom

In-built database facilities for up to 50 contamers and 4000 products are provided
so that input into these screens can be carried out with minimal effort. If
information for a particular product code is already held in the 4000 product
database then this is automatically entered into the appropriate fields. The first
option will attempt to pack as much of the medicines using any of the packing
methods available to medical shop management. This may be a loading from the
floor or from the end of the container. The second and third options are self
explanatory and the one most appropriate to the practical circumstances should be
selected.

7.0 Aim of the Micro-Project —

 The aim of Microproject is to prepare report on Medical store management system.

8.0 Course Outcomes Achieved —

b) Prepare the test cases for different types and levels of testing.

9.0 Literature Review-

In this system, the management needs not to keep any type of registers, which
they use to keep in old one. They have work only with one computer. All the
details are stored in computer files. The dual entries are done very quickly as
entry in one file only, affects the other file where it has to record. In the way
there is no need to record the computer operator. The working
through registers system is not only very laborious and time consuming,
but there are number of errors found. In comparison to old system the proposed
system of computer processes many advantages.

Objectives

Accuracy

Security

• Time Saving
• Perform Repetitive Task Very Well
• Low Cost

• Easy Maintenance
• Easy Modification

• Attractive and Status

9.0.1 Module Description

1. Purchase Item -The medicines been purchased by the medical shop, the
details are recorded in the Purchase Item. Some of the details been recorded
by the Medical shop agent is the agency from which the medicines are
bought, item details such as item type, item name, quantity, manufacturing
 date, expiry date The operations that are been performed here: To add new
records Into the database, to modify an already existing record in the database
, to search a record and delete a record from the database.

2. Sales Item- The medicines been sold out by the medical shop, the details are
recorded in the Sales Item. Some of the details been recorded by the Medical
shop agent is the agency or the customer and their respective address to
whom the medicines are sold, item details such as item type, item name,
quantity, manufacturing date, expiry date etc. The operations that are been
performed here:
To search a record in the database and delete a record from the database.

3. Item Details -The medicine details such as name of the medicine, bill number,
manufacturing date, expiry date, price and the quantity of the medicines etc
are been recorded in the Item Details.

4. Customer Billing -The bill for the medicines been purchased, is issued to the
Customer by the medical shop. The Customer bill contains the bill number,
purchase date, details of the item such as medicine type, name, price,
quantity, manufacturing date, expiry date etc. The operations that are been
performed here: To print the record ,to modify an already existing record in
the database ,to search a record and delete a record from the database.

5. Stock Details- The Stock details deals with the details of the agency as well
as the stock item such as the item type, item name, price and quantity. The
operations that are been performed here: To display the sales details of the
stock as recorded in the database search a record in the database.

9.0.2 Data Flow Diagram

Data flow oriented techniques advocate that the mapr data items handled by a
system must be first identified and then the processing required on these data
items to produce the desired outputs should be determined. The DFD (also called
as bubble chart) is a Simple graphical formalism that can be used to represent a
system in terms of input data to the system, various processing carrqed out on
these data, and the output generated by the system. It was introduced by De
Macro (1978), Gane and Sarson (1979).The primitive symbols used for
constructing DFD's are:

Symbols used in DFD

A circle represents a process.

A rectangle represents external entity

A square defines a source or destination of the system data.

An arrow identifies dataflow.

Double line with one end closed indicate data store.

Fig 9.0.21— Data Flow Diagram(DFD)
10.0 Actual Methodology Followed-
Waterfall Model is used to develop medical Store management system.

Fig - 10.0.] Waterfall Model

Reason For choosing WaterFall Model

1. This is Small Project and Requirements Are Well understood.
2. This model is simple and easy to understand and use.
3. Waterfall model is simple to implement and also the amount of resources
required for it are minimal
 4. It is easy to manage due to the rigidity of the model - each phase has specific
deliverables and a review process.
5. In this model, output is generated after each stage (as seen before), Therefore it
has high visibility. The client and project manager gets a feel that there is
considerable progress. Here it is important to note that in any project
psychological factors also play an important role.
6. In this model phases are processed and completed one at a time. Phases do not
overlap. This Project Is Conversion From Manual To Automatic.

Advantages and Disadvantages Advantages -

1. This system provides an easy way for the casher to determine whether the
customer is a valid member so that he can provide them with discount.
2. This system is also provides great help to the casherto add or update new or
existing members respectively

Disadvantage -
1 As every coin has a two side this system also suffers from disadvantage.
2. Multiple medicines can not be checked for a customer.

11.0 System Testing

Testing is an activity to verify that a correct system is being build and if perform with
the Intention of results once gathered and evaluated provide a qualitative indication
of software quality and reliability and serve as a basis for design modification. A
project is said to be incomplete without proper testing.

Testing Levels
System testing is the stage of implementation that is aimed at ensuring that the
system works accurately and efficiently before live operation commences. Testing is
vital for the success of the system. System testing makes a logical assumption that if
all parts of the system are correct, the goal will be successfully achieved.
A series of tests are performed for the proposed system is ready for User Acceptance
Testing, The testing steps are
• Unit Testing
• Integration Testing
 • Validation Testing
• Output Testing
• User Acceptance Testing

1. Unit Testing - Unit testing focuses verification efforts on the smallest unit of
software design, the machine module. This is also known as "MODULE TESTING".
The modules are tested separately is carried out during programming stage itselE In
this step, each module is found to be working satisfactory, So the expected output
from the module is arrived.

2. Integration Testing - Data can be lost across and interface, one module can have an
adverse effect on others, and sub-functions when combined may not produce the
desired major functions. Integration Testing is a Systematic Structure, while at the
same time conducting to uncover errors associated within the interfaces. The
objective is to take unit-tested modules and to combine them and test it as a whole.
Here correction is difficult because the vast expenses of the entire program
complicate the isolation of causes. This is the integration testing step. All the errors
encountered will be carried over to the next testmg step.

3. Validation Testing - Validation testing is performed In order to find whether there is

any flow and deficiency in requirements of the system. Each and every module is
tested independently. The input and output process are validated effectively. The
input of the user for each field is validated to check if value entered is null (or) valid.
After field level validation, the module level is made such that they are integrated
and a validation is performed for the whole system

4. Output Testing - After performing the validation, the next is output testing of the
proposed system. Since no system could be useful. If it does not produce the
required output in the special format asking the user about the requirement, test the
output generated (or) displayed by the system. Hence the output format is considered
in two ways. On is on of the screen and other is printed format.
 5. User-Acceptance Testing - User-Acceptance of a system is the key factors for the
success of any system. The system under consideration is tested for user acceptance
by constantly keeping in touch with the perspective system users at the time

Sign up form

Objective Excepted Result Actual Result Status

TC 1 Sign up id User id / Phone no User id Pass
should not less
than
TC 2 Password 8 character Actual Password Pass

TC 3 enable security password/ Face password pass

4 Login id User id / phone no. User id pass
TC 5 Password Correct Password Password accepted Pass

TC 6 OTP OTP send OTP Verified pass

7 Login status Login sucessfully Login pass

Login form

Objective Excepted Result Actual Result Status

 Open the desktop
TC 1 application Home page Enter in Home page Pass

TC 2 Enter valid login id User id Phn no User id pass

Enter Valid should not less than
TC 3 password 8 character Password accepted pass
On the click of
TC 4 login button Login sucessfully Login Pass

Customer / supplier / medicine Entry form

TC ID Objective Excepted Result Actual Result Status

 user have to fill
all field with
proper data, if any
Error like entering
text data instead of
number or
entering number
instead of text..is
On the click of found then it gives Added Record to
TC 1 ADD button proper message the Database Pass

On the click of Deletes the details

TC 2 DELETE Button in database Deleted sucessfully Pass
Modified records
On the click of are updated in Record has been
TC 3 UPDATE Button database updated sucessfully Pass

TC 4 On the click of searching by Options are

SEARCH Button entering Name. displayed Pass
On the click of
EXIT Button
TC 5 should be Exit Exit sucessfully Pass
 Stock
Objective Excepted Result Status

l) If quantities less than

100 than message show
with yellow color 2) If
quantities equal to O
On the click of than message show with checked
TC 1 Check quantites Red color sucessfull Pass

user have to fill all field

with proper data, if any
Error like entering text
data instead of number
or entering number
instead of text..is found Added Record
On the click of then it gives proper to the
TC 2 ADD button message Database Pass

On the click of Deletes the details of Deleted

TC 3 DELETE Button stock in database sucessfully Pass

Record has
On the click of Modified records are been updated
TC 4 UPDATE Button updating in database sucessfully Pass

On the click of
TC 5 EXIT Button Should be Exit Exit sucessfully Pass
 Customer bill

Objective Excepted Result Actual Result Status

On the click of
Displaying Verified Customer
TC 1 display Pass
Customer info. info
Customer info
TC 2 Payment Type Cash/Card cash Pass
On the click of
TC 3 Generated bill
Generate bill Generating bill Pass

On the click of saves the customers

TC 4 bill details in Pass
save button
database. saved sucessfully
On the click of
TC 5 should be Exit Pass
EXIT Button Exit sucessfully
 Sale Invoice form

TC ID Objective Excepted Result Actual Result Status

On the click of Calculates the total Calculated
TC 1 Pass
calculate button amount sucessfully
This saves the
On the click of
TC 2 details of sale Pass
save button
in database. saved sucessfully
On the click of loads the sale table Sale table
TC 3 Pass
Load Table button from database displayed
On the click of
TC 4 should be Exit
EXIT Button Exit sucessfully Pass

12.0 Actual Resources Used —

Sr. No. Name of Resource Specifications

1 Computer system Processor i7 RAM-8GB

2 Operating System Windows 10

3 Software Microsoft word, Microsoft Excel

13.0 Skills Developed -

I After working on the allotted microproject topic, I gained various skills like working
in team, making coordination between team members.
2. This project also made me increase my various skills.
3. Such project work increases our knowledge other from the regular course work.

Applications of this Micro-project -

The Proposed medical management is the completely computerized.
1 In proposed system there is no need to maintain data about medicine because all
process of that data done in computerized.
2. The modern age the age of computer is an electronic device, which fetched
record very quickly. The computers are very quickly accepted in trade line as it
as many advantages such as speed, accuracy, security etc,
3. In this proposed system all the add, edit, delete, search in project of computer are
done through computerized system.
4. Easy and fast retrieval of information.
5. Better storage capability. More efficient operation.
6. Well Designed report.
Eliminate the repeated data entry effort and errors.
 Micro-Proiect Evaluation Sheet

Roll Student Enrollment Process Product Total

No. Name Number Assessment Assessment Mark
(10)
34. Neha 19014801 Part A Project Part B Individu
Pawar 42 Method
56. Project ology Project Present
Shweta 19014801 Propos (2) report/ ation/Vi
Bhargude 65 workin va
g (4)
model
2
Comments/Suggestion about team work/Leadership/inter
personal communication (if any):

Any other comments:

Name of the Faculty Member

Signature(Prof. Jyoti mante)