ArgoUML



Region
	
RegionName PK
	
Farms
	
ClaimHistory
	
CurrentClaim FK



Farm
	
FarmName
	
FarmerName
	
Address
	
ClaimNo PK
	
RegionName
	
NoOfCows
	
NoOfBulls
	
NoOfSheep
	
NoOfPigs
	
NoOfGoats
	
Cereal
	
Oilseed
	
Linseed
	
Protein
	
PhoneNumber
	
CurrentSubsidyEntitlement



Region to farm = 1 to many

Farm to crops = 1 to many



Crops
	
CropType PK
	
SubsidyRate



Farm to animal = 1 to many


Animal
	
AnimalType PK
	
SubsidyRate



Region contains farm

Farm owns crops and animal



ClaimHistory
	
ClaimNo
	
ClainAmount
	
Date
	
ClaimCount PK
	
RegionName FK
	







CurrentClaim
	
ClaimNo PK
	
ClaimAmount
	
Date
	
RegionName FK





Region to ClaimHistory = 1 to many

Region has ClaimHistory

Region has CurrentClaim

Region to CurrentClaim = 1 to many

Farm has ClaimHistory

Farm has CurrentClaim
Claim
History to farm = 1 to 1

CurrentClaim to farm = 1 to 1


Region links to Farm and ClaimHistory

Farm links to Region, ClaimHistory, Animal, Crops, CurrentClaim

ClaimHistory links to Region and Farm

CurrentClaim links to Farm

Animal links to Farm

Crops links to Farm