## Farms

FarmID | Name | Location
--- | --- | ---
1 | Farm A | Location A
2 | Farm B | Location B
3 | Farm C | Location C
4 | Farm D | Location D
5 | Farm E | Location E

## Crops

CropID | CropName | YieldPerAcre
--- | --- | ---
1 | Wheat | 6000.0
2 | Corn | 18000.0
3 | Rice | 3500.0
4 | Barley | 2700.0
5 | Oats | 1900.0

## SoilTypes

TypeID | TypeName
--- | ---
1 | Clay Loam
2 | Sandy Loam
3 | Silty Clay Loam
4 | Gravelly Sandy Loam
5 | Loamy Sand

## WeatherConditions

ConditionID | Description
--- | ---
1 | Sunny
2 | Cloudy
3 | Rainy
4 | Windy
5 | Stormy

## FarmsSoil

FarmID | SoilTypeID
--- | ---
(→ Farms.FarmID) | (→ SoilTypes.TypeID)
1 | 1
1 | 2
2 | 3
2 | 4
3 | 5

## CropsWeather

CropID | ConditionID
--- | ---
(→ Crops.CropID) | (→ WeatherConditions.ConditionID)
1 | 1
1 | 2
2 | 3
2 | 4
3 | 5

## FarmsCrops

FarmID | CropID | Quantity | PlantingDate | HarvestDate
--- | --- | --- | --- | ---
(→ Farms.FarmID) | (→ Crops.CropID) |  |  |
1 | 1 | 500 | 2022-04-01 | 2022-09-01
1 | 2 | 300 | 2022-04-01 | 2022-09-01
2 | 3 | 200 | 2022-04-01 | 2022-09-01
3 | 1 | 400 | 2022-04-01 | 2022-09-01
4 | 2 | 100 | 2022-04-01 | 2022-09-01
2 | 1 | 200 | 2022-04-01 | 2022-09-01
4 | 1 | 100 | 2022-04-01 | 2022-09-01
5 | 1 | 0 | None | None