## Brands

id | brand_name
--- | ---
1 | John Deere
2 | Caterpillar
3 | New Holland
4 | Case IH
5 | Fendt

## Agricultural_Machinery_Stores

store_id | store_name | location
--- | --- | ---
1 | Store A | 123 Main St
2 | Store B | 456 Elm St
3 | Store C | 789 Oak St
4 | Store D | 012 Pine St
5 | Store E | 345 Maple St

## Machines

machine_id | model_number | description
--- | --- | ---
1 | Model X | Tractor Model X from John Deere.
2 | Model Y | Combine Harvester Model Y by New Holland.
3 | Model Z | Plow Model Z made by Case IH.
4 | Model W | Tiller Model W produced by Fendt.
5 | Model V | Seeder Model V created by Caterpillar.

## Stores_Brands

store_id | brand_id
--- | ---
(→ Agricultural_Machinery_Stores.store_id) | (→ Brands.id)
1 | 1
2 | 1
3 | 1
4 | 1
5 | 1
5 | 2