Fertilizers

idnamequantity
1Fertilizer1100.0
2Fertilizer2150.0
3Fertilizer3200.0
4Fertilizer4250.0
5Fertilizer5300.0

Components

idcomponentName
1Nitrogen
2Phosphorus
3Potassium
4Calcium
5Magnesium

FarmerInfo

idfarmerNamefarmLocation
1Farmer1New York
2Farmer2Chicago
3Farmer3Los Angeles
4Farmer4Houston
5Farmer5Philadelphia

Crops

idcropNameyield
1Wheat7000.0
2Corn8000.0
3Rice6000.0
4Barley5000.0
5Oats4000.0

Farmers_Crops

farmerIdcropId
(→ FarmerInfo.id)(→ Crops.id)
11
12
21
23
31

Fertilizers_Components

fertilizerIdcomponentId
(→ Fertilizers.id)(→ Components.id)
11
12
21
23
31
41
51