Dairy Management System 1d6z4v
This document was ed by and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this report form. Report 2z6p3t
Overview 5o1f4z
& View Dairy Management System as PDF for free.
More details 6z3438
- Words: 1,733
- Pages: 69
Project Presentation On Dairy Management System
Department of Computer Science Ganpat University, Kherva. M.sc(CA&IT) Sem - III Group No :-114
Presented By Harshad Patel(13084231113) Nikhil Patel (13084231156)
Project Profile Project Definition
Dairy Management System
Objective
To Provide Basic Facility Manage Organization Schedule and work.
Front End
PHP 5.4.16
Back End
MySQL 5.6.12
Other tools
MS Office 2003 , MS Office 2007
Operating Environment
Window XP Any Compatible OS
Project Internal Guide
Mr. Dhaval K. Raval
Project Duration
90 Days
Submited To
Department of Computer Science
Developed By
Patel Harshad. J Patel Nikhil. N
Existing System • When we Analysis the Manage about this firm then we face that they working with manual. And we all know that the manual system has many disadvantages. Some are mentioned below… – – – – – – – –
The manual system requires more time for processing. It requires more critical work. The manual system is more error prone. Difficult to maintain. Manual system is costly. Immediate response to the queries is difficult and time consuming. More men power needed. Menual system show of the particular place.
Need for New System • New system is required because of some advantage of new system are as below… – – – – –
The new system required less time for completion of any work. New system is decreasing the chances of error. New system should work smoothly and very fast. New system saving time and manpower. The system is friendly and any one having computer knowledge can handle it easily. – Suitability for computerized data entry. Maintaining Dairy information, Staff information & Customer information, Milk Rate Information.
Function Specification • • • •
:1. 2.Manage Milk Rate 3.Manage Staff 4.Manage Seller
• • • • • •
STAFF Seller Registration Manage Milk Rate Manage Insert Dairy Milk Seller Bill
• • • • • • `
:1.Registration 2. 3.View Rate Of Milk 4.View Service Facility 5.View SellMilk 6.
Hardware and Software Requirement Server Side:Minimum Hardware Requirement :Processor
1.60GHz
RAM
512 MB
Hard Disk
40 GB Minimum Software Requirement :-
Front End
PHP 5.4.16
Back End
My SQL 5.6.12
Operating System
Window XP any Compatible OS
Web Server
Apache 2.4.4
Client Side:Minimum Hardware Requirement :-
Processor
1.60GHz
RAM
512 MB
Hard Disk
40 GB
Operating System
Window XP or any Compatible Operating System
Browser
Internet Explorer 6.0 or any Compatible browser
System Flowchart:-
Timeline chart
E-R Diagram
USECASE DIAGRAM FOR
USECASE DIAGRAM FOR STAFF
USECASE DIAGRAM FOR SELLER
ACTIVITY DIAGRAM FOR
ACTIVITY DIAGRAM FOR STAFF
ACTIVITY DIAGRAM FOR SELLER
CLASS DIAGRAM
SEQUENCE DIAGRAM FOR
SEQUENCE DIAGRAM FOR STAFF
SEQUENCE DIAGRAM FOR SELLER
COLLOBRATION DIAGRAM FOR
COLLOBRATION DIAGRAM FOR STAFF
COLLOBRATION DIAGRAM FOR SELLER
Data Dictionary
Table Name Primary Key Description
Sr No.
Field Name
:- Table :- _Id :- This table is use for stored and
Data Type
Size
Constraint
1.
Id
varchar
15
Primary Key
2.
varchar
10
Not Null
Description It Stores Id
It Stores
Table Name :- Staff Table Primary Key :- S_Code Description :- This table is use for stored Seller Id,Seller Code, Name,Address, Registration Date and Animal Cattle. Sr. No.
Field Name
Data Type
Size
Constraint
Description It Store Staff No
1.
S_No
Int
10
Primary Key
2.
S_Name
varchar
50
NotNull
It StoresName
3.
Gender
varchar
50
NotNull
It Stores Address
4.
Address
varchar
50
NotNull
It Stores Address
5.
Work
varchar
20
NotNull
It StoresPost Of Staff
6.
Salary
bigint
20
NotNull
It StoresStaff Salary
7.
Phone No
bigInt
20
NotNull
It StoresStaff Phone No
8.
R_Date
date
NotNull
It Stores Registration Date
Table name Primary Key Description
Sr.
:- Milk Rate Table :- Fat :-This table is use for stored Fat, Buffalo & Cow Milk Rate, and Updated Date of the milk Rate
Field Name
No. 1.
Size
Constraint
Description
float
10,1
Primary Key
It Stores Fat of Milk
Data Type
Fat
2.
Buffalo
float
10,2
NotNull
It Stores Rate of the Milk
3.
Cow
float
10,2
NotNull
It Stores Rate of the Cow
Milk 4.
Udate
date
NotNull
It Stores Updated Dated
Table Name Primary Key Foreign Key Description
Sr. No.
Field Name
:- Seller Table :- S_Code :- _Id :- This table is use for stored Seller Code, Name, Address, Registration Date and Animal Cattle. Data Type
Size
Constraint
Description
1.
S_Code
Int
50
Primary Key
It Stores Id
2.
_Id
Varchar
15
Foreign Key
It Stores Code
3.
S_Name
varchar
50
NotNull
It Stores Name
4.
Address
varchar
50
NotNull
It Stores Address
5.
Ani_Cattle
varchar
50
Nit Null
It Stores Animal Cattle
5.
R_Date
date
NotNull
It Stores Registration Date
6.
Sell Milk
varchar
NotNull
It Stores Seller Sell Milk
50
Table Name Primary Key Foreign Key Description Sr. No.
::::-
Table Name _Id This table is use for stored Name, Address, Taluka, Distiction, Phone No, Email Address, and .
Field Name
Data Type
Size
Constraint
Description
1.
Name
varchar
25
Primary Key
It Stores Name of
2.
_Id
Varchar
15
Foreign Key
It Stores Id
3.
Address
varchar
50
NotNull
It Stores Address of
4.
Taluka
varchar
20
NotNull
It Stores Taluka of
5.
Distiction
varchar
20
NotNull
It Stores Distiction of
6.
Phone No.
bigint
20
NotNull
It Stores Phone Number of
7.
Email Address
varchar
25
NotNull
It Stores Email-Id of
8.
varchar
50
NotNull
It Stores of
Table Name Primary Key Foreign Key Description
Sr. No.
:- Daily_Milk_Data Table :- did :-_Id :-This Table use for stored Id, Seller Id, Quntity, Cattle, Milk Fat and Submitted
Field Name
Data Type
Size
Constraint
Description
Bigint
20
Primery Key
It Stores Id
15
Foreign Key
It Stores S_id
NotNull
It Stores Quntity
1.
Did
2.
_Id
int
3.
Quntity
Float
4.
Cattle_Type
5. 6.
varchar
30
NotNull
It Stores Animal Cattle
Fat
Float
50
Nit Null
It Stores Animal Milk Fat
Submit
date
NotNull
It Stores Registration Date
Table Name Primary Key Foreign Key Description
Sr. No.
:- Bill Table :- did :-_Id :-This Table use for stored Bid, Id,Total Milk Quntity,Total Amount Payable, Bill Date and Submitted
Field Name
Data Type
Size
Constraint
Description
1.
Bid
Int
10
Primery Key
It Stores Bill Id
2.
_Id
int
15
Foreign Key
It Stores _Id
3.
Total_Milk_Quntity
Float
NotNull
It Stores Total Milk Quntity
4.
Total_AMT_Payable
Double
NotNull
It Stores Amount Payable
5.
Bill_Date
Date
Not Null
It Stores Bill Date
Input Design
Home Page Discription :- This Page is Home Page
Page Discription :- This Page use for page.
Home Page Discription :- This page use for Home Page
Seller Page Discription :- This page use for Manage Seller Page
Milk Rate Page Discription :- This page use for Manage Milk Rate Page
Staff Page Discription :- This page use for Manage Staff Registration Page
Page Discription :- This page use for Manage Page
Staff Page Discription :- This page use for Staff Page
Seller Page Discription :- This page use for Manage Seller Page
Milk Rate Page Discription :- This page use for Manage Milk Rate Page
Page Discription :- This page use for Manage Page
Seller Milk Page Discription :- This page use for Manage Seller Milk Daily Insert Data Page
Seller Bill Page Discription :- This page use for Manage Seller Bill Page
Seller Home Page Discription :- This page use for Seller Home Page
Milk Rate Page Discription :- This page use for Seller View Milk Rate Page
Profile Page Discription :- This page use for View Seller Profile Page
Page Description :- This page use for Give Seller Page
Milk Data Page Discription :- This page use for View Seller Milk Data Page
Page Discription :- This page use for Page
Service Facility Page Discription :- This page use for Service Facility Page
Milk Storage Page Discription :- This page use for Milk Storage Page
Us Page Discription :- This page use for Us Page
Output Design
Seller Page Discription :- This page use for seller sell milk add details page
Seller List Page Discription :- This page use for seller sell milk show details page
Milk Rate Page Discription :- This page use for milk rate list Update page
Milk Rate Page Discription :- This page use for milk rate list page
Bord of Directors Page Discription :- This page use for add staff member add for her details page
Staff List Discription :- This page use for staff details
List Discription :- This page use for List Page
Seller Bill Detail Page Discription :- This page use for Seller Bill Detail Page
TESTING TEST CASES:1. :-
No
1
Test cases
Case Type
1.Invalid name
Expected
Actual
Result
Result
The system will
The system will
not accept the
not allow to
invalid name
into the system
/Fail
and throws error 2.Invalid
The system will
The system will
not accept the
not allow to
invalid
into the system
and throws error
2
Validation Testcase
1.Require field
Field should not
s have to
validation
be empty
enter the value
2. SELLER SEARCH:-
No
1
Test cases
Seller
Case Type
Expected
Actual
Result
Result
1.Invalid Seller
The system
The system
Code
will not accept
will not
the invalid
allow to
number
other Data
The system
The system
2.Valid Seller Code
will accept the will allow invalid number
number
/Fail
14. POST IMPLEMENTATION REVIEW
Post Implementation review is conducted by s and Analyst
To Evaluate the system , following questions are considered Is seller can see milk rate ? How can manage milk rate staff detail ,seller detail How staff can manage milk rate and ?
15. FUTURE ENHANCEMENT
•
Seller can see purchase sell milk show to online.
•
Seller can her payment direct in her .
•
Costomer Also be an of the system.
•
System need to be improve performance.
16. BIBLIOGRAPHY
BOOK REFERRED: • Book Name: PHP6 and My SQL • Author Name: Steve Suehring, Tim Converse, and Joyce Park • • •
SITE REFERRED: http://www.w3schools.com http://www.dhudhsagar.com http://www.banasdairy.com
Department of Computer Science Ganpat University, Kherva. M.sc(CA&IT) Sem - III Group No :-114
Presented By Harshad Patel(13084231113) Nikhil Patel (13084231156)
Project Profile Project Definition
Dairy Management System
Objective
To Provide Basic Facility Manage Organization Schedule and work.
Front End
PHP 5.4.16
Back End
MySQL 5.6.12
Other tools
MS Office 2003 , MS Office 2007
Operating Environment
Window XP Any Compatible OS
Project Internal Guide
Mr. Dhaval K. Raval
Project Duration
90 Days
Submited To
Department of Computer Science
Developed By
Patel Harshad. J Patel Nikhil. N
Existing System • When we Analysis the Manage about this firm then we face that they working with manual. And we all know that the manual system has many disadvantages. Some are mentioned below… – – – – – – – –
The manual system requires more time for processing. It requires more critical work. The manual system is more error prone. Difficult to maintain. Manual system is costly. Immediate response to the queries is difficult and time consuming. More men power needed. Menual system show of the particular place.
Need for New System • New system is required because of some advantage of new system are as below… – – – – –
The new system required less time for completion of any work. New system is decreasing the chances of error. New system should work smoothly and very fast. New system saving time and manpower. The system is friendly and any one having computer knowledge can handle it easily. – Suitability for computerized data entry. Maintaining Dairy information, Staff information & Customer information, Milk Rate Information.
Function Specification • • • •
:1. 2.Manage Milk Rate 3.Manage Staff 4.Manage Seller
• • • • • •
STAFF Seller Registration Manage Milk Rate Manage Insert Dairy Milk Seller Bill
• • • • • • `
:1.Registration 2. 3.View Rate Of Milk 4.View Service Facility 5.View SellMilk 6.
Hardware and Software Requirement Server Side:Minimum Hardware Requirement :Processor
1.60GHz
RAM
512 MB
Hard Disk
40 GB Minimum Software Requirement :-
Front End
PHP 5.4.16
Back End
My SQL 5.6.12
Operating System
Window XP any Compatible OS
Web Server
Apache 2.4.4
Client Side:Minimum Hardware Requirement :-
Processor
1.60GHz
RAM
512 MB
Hard Disk
40 GB
Operating System
Window XP or any Compatible Operating System
Browser
Internet Explorer 6.0 or any Compatible browser
System Flowchart:-
Timeline chart
E-R Diagram
USECASE DIAGRAM FOR
USECASE DIAGRAM FOR STAFF
USECASE DIAGRAM FOR SELLER
ACTIVITY DIAGRAM FOR
ACTIVITY DIAGRAM FOR STAFF
ACTIVITY DIAGRAM FOR SELLER
CLASS DIAGRAM
SEQUENCE DIAGRAM FOR
SEQUENCE DIAGRAM FOR STAFF
SEQUENCE DIAGRAM FOR SELLER
COLLOBRATION DIAGRAM FOR
COLLOBRATION DIAGRAM FOR STAFF
COLLOBRATION DIAGRAM FOR SELLER
Data Dictionary
Table Name Primary Key Description
Sr No.
Field Name
:- Table :- _Id :- This table is use for stored and
Data Type
Size
Constraint
1.
Id
varchar
15
Primary Key
2.
varchar
10
Not Null
Description It Stores Id
It Stores
Table Name :- Staff Table Primary Key :- S_Code Description :- This table is use for stored Seller Id,Seller Code, Name,Address, Registration Date and Animal Cattle. Sr. No.
Field Name
Data Type
Size
Constraint
Description It Store Staff No
1.
S_No
Int
10
Primary Key
2.
S_Name
varchar
50
NotNull
It StoresName
3.
Gender
varchar
50
NotNull
It Stores Address
4.
Address
varchar
50
NotNull
It Stores Address
5.
Work
varchar
20
NotNull
It StoresPost Of Staff
6.
Salary
bigint
20
NotNull
It StoresStaff Salary
7.
Phone No
bigInt
20
NotNull
It StoresStaff Phone No
8.
R_Date
date
NotNull
It Stores Registration Date
Table name Primary Key Description
Sr.
:- Milk Rate Table :- Fat :-This table is use for stored Fat, Buffalo & Cow Milk Rate, and Updated Date of the milk Rate
Field Name
No. 1.
Size
Constraint
Description
float
10,1
Primary Key
It Stores Fat of Milk
Data Type
Fat
2.
Buffalo
float
10,2
NotNull
It Stores Rate of the Milk
3.
Cow
float
10,2
NotNull
It Stores Rate of the Cow
Milk 4.
Udate
date
NotNull
It Stores Updated Dated
Table Name Primary Key Foreign Key Description
Sr. No.
Field Name
:- Seller Table :- S_Code :- _Id :- This table is use for stored Seller Code, Name, Address, Registration Date and Animal Cattle. Data Type
Size
Constraint
Description
1.
S_Code
Int
50
Primary Key
It Stores Id
2.
_Id
Varchar
15
Foreign Key
It Stores Code
3.
S_Name
varchar
50
NotNull
It Stores Name
4.
Address
varchar
50
NotNull
It Stores Address
5.
Ani_Cattle
varchar
50
Nit Null
It Stores Animal Cattle
5.
R_Date
date
NotNull
It Stores Registration Date
6.
Sell Milk
varchar
NotNull
It Stores Seller Sell Milk
50
Table Name Primary Key Foreign Key Description Sr. No.
::::-
Table Name _Id This table is use for stored Name, Address, Taluka, Distiction, Phone No, Email Address, and .
Field Name
Data Type
Size
Constraint
Description
1.
Name
varchar
25
Primary Key
It Stores Name of
2.
_Id
Varchar
15
Foreign Key
It Stores Id
3.
Address
varchar
50
NotNull
It Stores Address of
4.
Taluka
varchar
20
NotNull
It Stores Taluka of
5.
Distiction
varchar
20
NotNull
It Stores Distiction of
6.
Phone No.
bigint
20
NotNull
It Stores Phone Number of
7.
Email Address
varchar
25
NotNull
It Stores Email-Id of
8.
varchar
50
NotNull
It Stores of
Table Name Primary Key Foreign Key Description
Sr. No.
:- Daily_Milk_Data Table :- did :-_Id :-This Table use for stored Id, Seller Id, Quntity, Cattle, Milk Fat and Submitted
Field Name
Data Type
Size
Constraint
Description
Bigint
20
Primery Key
It Stores Id
15
Foreign Key
It Stores S_id
NotNull
It Stores Quntity
1.
Did
2.
_Id
int
3.
Quntity
Float
4.
Cattle_Type
5. 6.
varchar
30
NotNull
It Stores Animal Cattle
Fat
Float
50
Nit Null
It Stores Animal Milk Fat
Submit
date
NotNull
It Stores Registration Date
Table Name Primary Key Foreign Key Description
Sr. No.
:- Bill Table :- did :-_Id :-This Table use for stored Bid, Id,Total Milk Quntity,Total Amount Payable, Bill Date and Submitted
Field Name
Data Type
Size
Constraint
Description
1.
Bid
Int
10
Primery Key
It Stores Bill Id
2.
_Id
int
15
Foreign Key
It Stores _Id
3.
Total_Milk_Quntity
Float
NotNull
It Stores Total Milk Quntity
4.
Total_AMT_Payable
Double
NotNull
It Stores Amount Payable
5.
Bill_Date
Date
Not Null
It Stores Bill Date
Input Design
Home Page Discription :- This Page is Home Page
Page Discription :- This Page use for page.
Home Page Discription :- This page use for Home Page
Seller Page Discription :- This page use for Manage Seller Page
Milk Rate Page Discription :- This page use for Manage Milk Rate Page
Staff Page Discription :- This page use for Manage Staff Registration Page
Page Discription :- This page use for Manage Page
Staff Page Discription :- This page use for Staff Page
Seller Page Discription :- This page use for Manage Seller Page
Milk Rate Page Discription :- This page use for Manage Milk Rate Page
Page Discription :- This page use for Manage Page
Seller Milk Page Discription :- This page use for Manage Seller Milk Daily Insert Data Page
Seller Bill Page Discription :- This page use for Manage Seller Bill Page
Seller Home Page Discription :- This page use for Seller Home Page
Milk Rate Page Discription :- This page use for Seller View Milk Rate Page
Profile Page Discription :- This page use for View Seller Profile Page
Page Description :- This page use for Give Seller Page
Milk Data Page Discription :- This page use for View Seller Milk Data Page
Page Discription :- This page use for Page
Service Facility Page Discription :- This page use for Service Facility Page
Milk Storage Page Discription :- This page use for Milk Storage Page
Us Page Discription :- This page use for Us Page
Output Design
Seller Page Discription :- This page use for seller sell milk add details page
Seller List Page Discription :- This page use for seller sell milk show details page
Milk Rate Page Discription :- This page use for milk rate list Update page
Milk Rate Page Discription :- This page use for milk rate list page
Bord of Directors Page Discription :- This page use for add staff member add for her details page
Staff List Discription :- This page use for staff details
List Discription :- This page use for List Page
Seller Bill Detail Page Discription :- This page use for Seller Bill Detail Page
TESTING TEST CASES:1. :-
No
1
Test cases
Case Type
1.Invalid name
Expected
Actual
Result
Result
The system will
The system will
not accept the
not allow to
invalid name
into the system
/Fail
and throws error 2.Invalid
The system will
The system will
not accept the
not allow to
invalid
into the system
and throws error
2
Validation Testcase
1.Require field
Field should not
s have to
validation
be empty
enter the value
2. SELLER SEARCH:-
No
1
Test cases
Seller
Case Type
Expected
Actual
Result
Result
1.Invalid Seller
The system
The system
Code
will not accept
will not
the invalid
allow to
number
other Data
The system
The system
2.Valid Seller Code
will accept the will allow invalid number
number
/Fail
14. POST IMPLEMENTATION REVIEW
Post Implementation review is conducted by s and Analyst
To Evaluate the system , following questions are considered Is seller can see milk rate ? How can manage milk rate staff detail ,seller detail How staff can manage milk rate and ?
15. FUTURE ENHANCEMENT
•
Seller can see purchase sell milk show to online.
•
Seller can her payment direct in her .
•
Costomer Also be an of the system.
•
System need to be improve performance.
16. BIBLIOGRAPHY
BOOK REFERRED: • Book Name: PHP6 and My SQL • Author Name: Steve Suehring, Tim Converse, and Joyce Park • • •
SITE REFERRED: http://www.w3schools.com http://www.dhudhsagar.com http://www.banasdairy.com
Related Documents c2h70
Dairy Management System 1d6z4v
November 2021 0
Report Dairy Milk Management System 3n43m
November 2019 64
Final Year Report -dairy Management Information System 4j5w3h
November 2019 37
Project Profile -dairy Farm Management 3c1f4g
May 2020 3
Courier System Management-system Analysis 1s46g
October 2019 169
Cable Operator Management System (system) 48516z
October 2019 89More Documents from "Shashank Mahato" 4e4n5y
Dairy Management System 1d6z4v
November 2021 0
Brand Plan For Pharma Products - Lecture Slides 4w1i52
October 2021 0
Internship Report _ Hrm _ Central Railway Workshop, Mysore _ Final To Print (2) y2030
February 2022 0
Sanskrit Computational Linguistics 442mk
March 2023 0
Nism-series-i: Currency Derivatives Certification Examination 2h1t4x
November 2021 0