Dairy Project

Dairy Management System

Table list

Select * from CategoryMaster
Select * from SubCategoryMaster
Select * from CountryMaster
Select * from StateMaster
Select * from DistrictMaster
Select * from TalukaMaster
Select * from CityMaster
Select * from Configuration
Select * from SaluationMaster
Select * from GenderMaster
Select * from MilkTimeMaster
Select * from MilkTypeMaster
Select * from FATMaster
Select * from SNFMaster
Select * from RateMaster
Select * from MenuMaster
Select * from UserMaster
Select * from UserMenuMaster
Select * from Registration
Select * from DailyMilkCollection
Select * from DayEndCollection
Select * from CustomerLedger
Select * from Advance
Select * from Payment
Select * from Suppliment
Select * from Advance_Summery
Select * from BillProcess_CustomerPayment
Select * from BillProcess_Summery
Select * from DMC_Summery
Select * from Suppliment_Summery

SQL Queries are available on below link

DMS Project Part 1.create table script

Dairy Project Part 2.1 Insert data script

Dairy Project Part 2.2 .Insert Data script

Dairy Project Part 2.3 .Insert Data script

Dairy Project Part 3.Questions Answers

Part 1

Part 2

Part 3

Part 4

Part 5

Part 6