| id | brand_name |
|---|---|
| 1 | John Deere |
| 2 | Caterpillar |
| 3 | New Holland |
| 4 | Case IH |
| 5 | Fendt |
| 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 |
| 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. |
| store_id | brand_id |
|---|---|
| (→ Agricultural_Machinery_Stores.store_id) | (→ Brands.id) |
| 1 | 1 |
| 2 | 1 |
| 3 | 1 |
| 4 | 1 |
| 5 | 1 |
| 5 | 2 |