## Fertilizers

id | name | quantity
--- | --- | ---
1 | Fertilizer1 | 100.0
2 | Fertilizer2 | 150.0
3 | Fertilizer3 | 200.0
4 | Fertilizer4 | 250.0
5 | Fertilizer5 | 300.0

## Components

id | componentName
--- | ---
1 | Nitrogen
2 | Phosphorus
3 | Potassium
4 | Calcium
5 | Magnesium

## FarmerInfo

id | farmerName | farmLocation
--- | --- | ---
1 | Farmer1 | New York
2 | Farmer2 | Chicago
3 | Farmer3 | Los Angeles
4 | Farmer4 | Houston
5 | Farmer5 | Philadelphia

## Crops

id | cropName | yield
--- | --- | ---
1 | Wheat | 7000.0
2 | Corn | 8000.0
3 | Rice | 6000.0
4 | Barley | 5000.0
5 | Oats | 4000.0

## Farmers_Crops

farmerId | cropId
--- | ---
(→ FarmerInfo.id) | (→ Crops.id)
1 | 1
1 | 2
2 | 1
2 | 3
3 | 1

## Fertilizers_Components

fertilizerId | componentId
--- | ---
(→ Fertilizers.id) | (→ Components.id)
1 | 1
1 | 2
2 | 1
2 | 3
3 | 1
4 | 1
5 | 1