Dairy Management System

1.

A
Project Report
On
“Dairy Management System”

Developed by,
Musmade Sagar Vilas

In Partial Fulfillment Of
Master In Computer Science (MCS)
SAVITRIBAI PHULE PUNE UNIVERSITY

Rajarshi Shahu Mahavidyalaya, Deolali Pravara

Ahmednagar-414001
(2021-2022)

1
Dairy Management System

CERTIFICATE
Department of Computer Science
This is to certify that
Mr. Musmade Sagar Vilas
Student of

Rajarshi Shahu Mahavidyalaya,

Deolali Pravara

Has successfully completed his project on

“Dairy Management System”
as partial fulfillment of the course MCS
Affiliated to UNIVERSITY OF PUNE during the academic year
2021-2022.

____________________ ___________________
Prof. Patil Sir Incharge
Head of Department
____________________
Examiner
__________________ _________________
Internal Examiner External Examiner

2
Dairy Management System

ACKNOWLEDGEMENT

Any effort to produce successful creation requires the help,

guidance and support of many people and their experience. We
would like to express our sincere and heartfelt gratitude to all of
them.
We would like to take this opportunity to thanks all the people
who have directly or indirectly helped this project. We would like
to thank our guide Mrs. Anita Bankar, for her valuable guidance.

-Musmade Sagar

3
Dairy Management System

Table of Content
Sr. No. Contents Page No.
1 Introduction 1
2 Problem Definition 2
3 Need for System 3
4 Scope of Proposed System 4
5 Feasibility Study & Fact Finding Technique 5
6 Hardware and Software Requirement 6
7 Design Specification 7-10
7.1 Data Flow Diagram
7.2 ER Diagram
8 Data Dictionary 11-12
9 Table Design 13-15
10 Sample Input & Output Screen 16-23
11 Testing Strategy 24
12 Limitations 25
13 Future Enhancement 26
14 Conclusion 27
15 Bibliography 28

4
Dairy Management System

1. Introduction:
Dairy Management System is a software application to maintain day-to-day transaction in
milk distribution office. This software help to register all suppliers, customer’s details,
collection of milk details, distribution of milk details etc. This application is to automate
the complete operation of milk distribution office.

Our main goal to develop this application to encourage the dairy industry. To reduce the
manual workload of this administrative activities, organization began to electronically
automate many of this processes by introducing specialized Dairy Management System.

These department can be centrally controlled. Every department has facilities like add,
delete, modify, and view to handle the data base. In our system we try to remove all the
dairy processing problem occurred in manual system.

5
Dairy Management System

2. Problem Definition:-

 Lack Of Immediate Retrievals:-

The information is very difficult to retrieve & to find particular information.
 Information Storage:-
The information generated by various transaction takes time & efforts to be stored
at right place.
 Prompt Updating:-
Various changes to information like customer’s details or supplier’s details are
difficult to wake as paper work is involved.
 Error Prone Manual Calculations:-
Manual calculation are error prone & take a lot of time may result in incorrect
information.
 Preparation Of Accurate & Prompt Result:-
This becomes difficult task as information is difficult to collect from various
register.
 The Manual System Requires More Time.
 Therefore Manual System is Costly.
 More Man-power is needed.
 Earlier record keeping was done on paper.
 Data on the paper can also misplace due to human error or paperwork.
 Manual calculation takes a lot of time and this may result in incorrect
information.

6
Dairy Management System

3. Need For System:-

The new system requires less time for completion of any work.
New system is decreasing the chances of errors.
The system is user friendly and anyone having computer knowledge can handle it easily.
Suitable for computerized data entry.
Maintaining Dairy Information, staff Information, customer Information and milk rate
Information.
New system save time and manpower.

7
Dairy Management System

4. Scope Of The Proposed System:-

This application is built such a way that it should suit for all types of milk
distribution.
Dairy Management project is a software application useful for dairy farms for
managing daily activities like receiving of milk from various sources.
We designed a system computerized to remove the problem in exiting system,
which can become easier job to interact with system.
The proposed system is fast, user friendly.
It also reduced the time of giving output from system i.e. the response time is very
less.
It reduced time of giving output from system. Daily inventory manage option.
This is concerned with manpower planning. Print details and reports.

8
Dairy Management System

5. Feasibility Study:-
5.1 Technical Feasibility:-

In a technical feasibility we always try to focus on existing computer hardware and software.
So in this study we checked whether it is possible to develop a project with available hardware
and software.

5.2 Economical Feasibility:-

Economical feasibility is helpful to find the system development cost and also benefits. The

System can work on low cost hardware and also capable of getting maximum benefits.

5.3 Operational Feasibility:-

Operational feasibility consider acceptability of system also it check whether the user is able
to handle the system effectively and easily or he problem while working with system. In this
feasibility we checked system is user friendly or not.

5. Fact finding techniques:-

A key Part of feasibility is gathering information about the present system. The analyst knows
what information to gather to make of it.

5.1 Interviews:-
Analysts use interview to collect information from individuals who they consider
should be the sources, who are current users of the existing system. The analyst has a face
conversation with the user & administrator of the system& fixed set of questions prepared.

5.2 Questionnaire:-
It allows analyst to collect information from a group of individual who may or may
not be using the system thus resulting sometimes in irrelevant data redundancy.

5.3 Record Review:-

Consisting of analyzing the previews operation in the company & forecasting the
new future schemes. Records include table name, date & time creation, user login etc.

9
Dairy Management System

6. Hardware and Software Requirements:-

HARDWARE:-

Objects Content Used Currently

Hard Disc 400MB

Printer Inkjet

Processor Pentium III Or Higher Version

RAM 250 MB

SOFTWARE:-

S/W Name Use

Javascript Front End

Node js Back End

Windows 10 Operating System

10
Dairy Management System

7. Design Specification:-
7.1 ERD:-

11
 Dairy Management System

7.2 Activity Diagram:-

Login

Enter For the Supplier

& Customer Details

Enter Enter Daily Enter Enter Display

Daily Distribution Payment Rate Reports
Collection Setting Bills

Manager Supplier Manager Customer Manager Payment Manager Setting Manager Reports

Logout

12
Dairy Management System

7.3 Use Case Diagram:-

Cust & Supplier Details

Daily Collection

User
Daily Distribution
Supplier

Payment Details

Setting Rate Details

Reports

Customer
Reports Bills

Logout

13
Dairy Management System

7.4 Class Diagram-:

Supplier Class Collection Class

+SerialNo:int
+role_id:int
+SupplierID:Int
+role_Name:string
+TypeOfMilk:string
+role_add:string
+Fat:Int

User class Distribution class

+UserID:String +SerialNo:Int
+Password:string +CustName:string
+Color:String +TypeOfMilk:String
+MilkQuantity:Int

Customer class
Payment class

+CustID:Int
+CustID:Int
+CustName:string
+SupplierID:Int
+CustAdd:String
+Amount:Int
+Type:String
+Paid:String

14
Dairy Management System

8. Data Dictionary:
Sr
No Field Name Data type Belong Description
1 UserID Short text Login User ID
2 Password Short text Login User password
3 Name Short text NewReg Admin name
4 UserID Short text NewReg Admin ID
5 Password Short text NewReg Admin password
6 Color Short text NewReg Admin Favorite color
7 SupplierID Number SupplierAccount Supplier ID
8 SupplierName Short text SupplierAccount Supplier Name
9 Address Short text SupplierAccount Supplier Address
10 Type Short text SupplierAccount Supplier Type
11 Phone Short text SupplierAccount Supplier Contact
12 Date Short text SupplierAccount Supplier Registration date
13 SerialNo Number SupPayment Supplier ID
14 SupplierName Short text SupPayment Supplier Name
15 Total Short text SupPayment Total bill
16 Date Date/Time SupPayment Date of Bill
17 Paid yes/no SupPayment Bill paid or not
18 CustID Number CustomerAccount Customer ID
19 CustName Short text CustomerAccount Customer Name
20 Address Short text CustomerAccount Customer Address
21 Type Short text CustomerAccount Customer Type
22 Phone Short text CustomerAccount Customer Contact
23 Date Short text CustomerAccount Customer Registration date
24 SerialNo Number CustPayment Customer ID
25 CustID Number CustPayment Customer Name

15
Dairy Management System

26 Date Date/Time CustPayment Payment Date

27 Total Short text CustPayment Bill total
28 Paid yes/no CustPayment Bill Paid or not
29 SerialNo Number DailyCollection Serial no of collection
30 SupplierID Number DailyCollection Supplier ID
31 Name Short text DailyCollection Supplier Name
32 TypeOfMilk Short text DailyCollection Milk Type
33 MilkQuantity Number DailyCollection Quantity of milk
34 Fat Number DailyCollection Fat
35 TotalPrice Currency DailyCollection Total bill
36 Ddate Date/Time DailyCollection Date of collection
37 SerialNo Number DailyDistribution Serial no of Distribution
39 CustName Short text DailyDistribution Customer Name
40 MilkQuantity Number DailyDistribution Quantity of milk
41 Type Short text DailyDistribution Type of Milk
42 TotalPrice Currency DailyDistribution Total bill
43 Date Date/Time DailyDistribution Date of distribution
44 Fat Number FatMaster Fat of milk
45 Rate Number FatMaster Rate of milk
46 Type Short text MilkRate Type
47 MilkRate Number MilkRate Milk rate of cow

16
Dairy Management System

9. Table Design:-
Login
 Table:
Data
Sr.No Field Name Type Size Constraint
1 UserID Short text 30 Not Null
2 Password Short text 30 Not Null

NewReg
 Table:
Sr.No Field Name Data Type Size Constraint
1 UserID Short text 30 Not Null
2 Password Short text 30 Not Null
3 Color Short text 30 Not Null

SupplierAccount
 Table:
Sr.No Field Name Data Type Size Constraint
1 SupplierID Number 10 Primary key
2 SupplierName Short text 30 Not Null
3 Address Short text 30 Not Null
4 Type Short text 30 Not Null
5 Phone Number 10 Not Null
6 Date Date/Time Not Null

SupPayment:
 Table:
Sr.No Field Name Data Type Size Constraint
1 SerialNo Number 10 Primary key
2 SupplierName Short text 30 Foreign Key
3 Total Short text 30 Not Null
4 Date Date/Time Not Null
5 Paid Short text 30 Not Null

17
Dairy Management System

CustomerAccount:
 Table:
Sr,.No Field Name Data Type Size Constraint
1 CustID Number 10 Primary key
2 CustName Short text 30 Not Null
3 Address Short text 30 Not Null
4 Type Short text 30 Not Null
5 Phone Number 10 Not Null
6 Date Date/Time Not Null

CustPayment:
 Table:
Sr.No Field Name Data Type Size Constraint
1 SerialNo Number 10 Primary key
2 CustID Number 10 Foreign Key
3 Date Date/Time Not Null
4 Total Short text 30 Not Null
5 Paid Short text 30 Not Null

DailyCollection:
 Table:
Sr.No Field Name Data Type Size Constraint
1 SerialNo Short text 10 Primary key
2 SupplierID Number 10 Foreign key
3 Name Short text 30 Not Null
4 TypeOfMilk Short text 30 Not Null
5 MilkQuantity Number 10 Not Null
6 Fat Number 10 Not Null
7 TotalPrice Currency Not Null

18
Dairy Management System

8 Ddate Date/Time Not Null

DailyDistribution:
 Table:
Sr.No Field Name Data Type Size Constraint
1 SerialNo Number 10 Primary key
2 CustID Number 10 Foreign key
3 Name Short text 30 Not Null
4 MilkQuantity Number 10 Not Null
5 Type Short text 30 Not Null
6 TotalPrice Currency Not Null
7 Date Date/Time Not Null

FatMaster:
 Table:
Sr.No Field Name Data Type Size Constraint
1 Fat Number 10 Not Null
2 Rate Number 10 Not Null

MilkRate:
 Table:
Sr.No Field Name Data Type Size Constraint
1 Type Short text 30 Not Null
2 MilkRate Number 10 Not Null

19
Dairy Management System

10. Sample Input & Output Screen:-

 Login Form: -

20
Dairy Management System

 Supplier Form:-

21
Dairy Management System

 Menu Form:-

22
Dairy Management System

 Customer Form:-

23
Dairy Management System

 Collection Form:-

24
Dairy Management System

 Distribution Form:-

25
Dairy Management System

 Customer Payment Form:-

26
Dairy Management System

 Milk Rate Form:-

27
Dairy Management System

 Customer Report:-

 SupPaymentRpt:-

28
Dairy Management System

 DailyCollectionRpt:-

29
Dairy Management System

 Supplier Report:-

 CustPaymentRpt:-

30
Dairy Management System

 DailyDistributionRpt:-

31
Dairy Management System

11. Testing Strategy:-

 Unit Testing:-

In this testing each and every program is tested individually using record to weather
that program produce satisfactory output and validation also.
Unit testing focuses efforts on the smallest unit of software design.
This known as module testing.
 Black Box Testing:-
Is a software testing method in which the internal structure/ design/ implementation
of the item being tested is NOT known to the tester.

 White Box Testing:-

Is a software testing method in which the internal structure/ design/
implementation of the item being tested is known to the tester.
 Integration Testing:-
After all the modules of our system were integrated we go for integrated testing.
And assure the flow form one module to other is going on smoothly or not.
 System Testing:-
Software and Hardware are integrated and a full range of system test is conducted
in and attempt to uncover errors at the software/hardware interface.

32
Dairy Management System

12. Limitations:-

 It was not possible to make software dynamic.

 User management logic is not included.
 Expenses are not been calculated.
 Not useful for large organization.
 Calculate only milk quantity.
 Offline payment system.
 The System is not working on network or online.

33
Dairy Management System

13. Future Enhancement:-

 The code is not perfect. Some in enhancement can be made in the code for improved
performance. We can improve the graphics, Database handling.
 The system is standalone does not work on Network. As system needed “windows
operating system” to run, we can make changes to run it on network.
 Managing salary component in database.
 We will also make the online pay system in future.
 This system used by two tier architecture.

34
Dairy Management System

14. Conclusion:-

I can conclude that dairy management information system can help both admin and
supplier in order to do their job.
It can help organization going smoothly using technology.

Organization can improve their management system from traditional approach to a modern
approach that using a technology base.

35
Dairy Management System

15. Bibliography:-

 Book referred:-
Book name: 1) Programming With java a primer 3rd edition E.Balagurusamy.

2) Effective javascript 3rd edition Joshua Bloch.

3) Java complete reference 11th edition Herbert Schildt.

4) Java performance The Definite guide 1st edition Scott oaks.

5) Thinking in javascript By Bruce Eckel.

Book name: Database Management Systems

Author name: Raghu Ramakrishnan.

36