Farms

FarmIDNameLocation
1Farm ALocation A
2Farm BLocation B
3Farm CLocation C
4Farm DLocation D
5Farm ELocation E

Crops

CropIDCropNameYieldPerAcre
1Wheat6000.0
2Corn18000.0
3Rice3500.0
4Barley2700.0
5Oats1900.0

SoilTypes

TypeIDTypeName
1Clay Loam
2Sandy Loam
3Silty Clay Loam
4Gravelly Sandy Loam
5Loamy Sand

WeatherConditions

ConditionIDDescription
1Sunny
2Cloudy
3Rainy
4Windy
5Stormy

FarmsSoil

FarmIDSoilTypeID
(→ Farms.FarmID)(→ SoilTypes.TypeID)
11
12
23
24
35

CropsWeather

CropIDConditionID
(→ Crops.CropID)(→ WeatherConditions.ConditionID)
11
12
23
24
35

FarmsCrops

FarmIDCropIDQuantityPlantingDateHarvestDate
(→ Farms.FarmID)(→ Crops.CropID)
115002022-04-012022-09-01
123002022-04-012022-09-01
232002022-04-012022-09-01
314002022-04-012022-09-01
421002022-04-012022-09-01
212002022-04-012022-09-01
411002022-04-012022-09-01
510NoneNone