DAIRY MANAGEMENT SYSTEM PROJECT REPORT

DAIRY MANAGEMENT SYSTEM PROJECT REPORT

DAIRY MANAGEMENT SYSTEM PROJECT REPORT

Dairy milk management system project ppt

DAIRY MILK MANAGEMENT SYSTEM PROJECT SOURCE CODE

FREE DOWNLOAD ALL THE PROJECT REPORTS WITH SOURCE CODE FROM HERE

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

• 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.

Existing 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 user 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.

Need for New System

 ADMIN :-

• 1.Login

• 2.Manage Milk Rate

• 3.Manage Staff

• 4.Manage Seller

 STAFF

• Login

• Seller Registration

• Manage Milk Rate

• Manage feedback

• Insert Dairy Milk

• Seller Bill

 USER :-

• 1.Registration

• 2.Login

• 3.View Rate Of Milk

• 4.View Service Facility

• 5.View SellMilk

• 6.Feedback

`

Function Specification

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

Data Dictionary

Sr

No.

Field Name Data Type Size Constraint Description

1. User Id varchar 15 Primary Key It Stores

User Id

2. Password varchar 10 Not Null It Stores

Password

Table Name :- Login Table

Primary Key :- User_Id

Description :- This table is use for stored User and Password

Sr.

No.

Field Name Data Type Size Constraint Description

1. S_No Int 10 Primary Key It Store Staff No

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 :- Staff Table

Primary Key :- S_Code

Description :- This table is use for stored Seller User Id,Seller Code,

Name,Address, Registration Date and Animal Cattle.

Sr.

No.

Field Name Data

Type

Size Constraint Description

1. Fat float 10,1 Primary Key It Stores Fat of Milk

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 :- Milk Rate Table

Primary Key :- Fat

Description :-This table is use for stored Fat, Buffalo & Cow Milk Rate,

and Updated Date of the milk Rate

Sr.

No.

Field Name Data Type Size Constraint Description

1. S_Code Int 50 Primary Key

It Stores

User Id

2. User_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 50 NotNull It Stores

Seller Sell Milk

Table Name :- Seller Table

Primary Key :- S_Code

Foreign Key :- User_Id

Description :- This table is use for stored Seller Code, Name,

Address, Registration Date and Animal Cattle.

Sr.

No.

Field Name Data Type Size Constraint Description

1. Name varchar 25 Primary Key It Stores

Name of User

2. User_Id Varchar 15 Foreign Key It Stores

User Id

3. Address varchar 50 NotNull It Stores

Address of User

4. Taluka varchar 20 NotNull It Stores

Taluka of User

5. Distiction varchar 20 NotNull It Stores

Distiction of User

6. Phone No. bigint 20 NotNull It Stores

Phone Number of User

7. Email Address varchar 25 NotNull It Stores

Email-Id of User

8. Feedback varchar 50 NotNull It Stores

Feedback of User

Table Name :- Feedback Table

Primary Key :- Name

Foreign Key :- User_Id

Description :- This table is use for stored User Name, Address,

Taluka, Distiction, Phone No, Email Address, and Feedback.

Table Name :- Daily_Milk_Data Table

Primary Key :- did

Foreign Key :-User_Id

Description :-This Table use for stored User Id, Seller Id, Quntity, Cattle,

Milk Fat and Submitted

Sr.

No.

Field Name Data Type Size Constraint Description

1. Did Bigint 20 Primery Key It Stores

User Id

2. User_Id int 15 Foreign Key It Stores

S_id

3. Quntity Float NotNull It Stores Quntity

4. Cattle_Type varchar 30 NotNull It Stores Animal Cattle

5. Fat Float 50 Nit Null It Stores

Animal Milk Fat

6. Submit date NotNull It Stores

Registration Date

Table Name :- Bill Table

Primary Key :- did

Foreign Key :-User_Id

Description :-This Table use for stored Bid,User Id,Total Milk Quntity,Total

Amount Payable, Bill Date and Submitted

Sr.

No.

Field Name Data Type Size Constraint Description

1. Bid Int 10 Primery Key It Stores

Bill Id

2. User_Id int 15 Foreign Key It Stores User_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

14. POST IMPLEMENTATION REVIEW

 Post Implementation review is conducted by Users and Analyst

 To Evaluate the system , following questions are considered

 Is seller can see milk rate ?

 How admin can manage milk rate staff detail ,seller detail

 How staff can manage milk rate feedback and feedback ?

• Seller can see purchase sell milk show to online.

• Seller can her payment direct in her account.

• Costomer Also be an user of the system.

• System need to be improve performance.

15. FUTURE ENHANCEMENT