| clubID | name | location |
|---|---|---|
| 1 | Sunshine Gardeners | New York |
| 2 | Green Thumbs Society | Los Angeles |
| 3 | Floral Friends | Chicago |
| 4 | Blossom Bunch | Miami |
| 5 | Nature Lovers | Dallas |
| plantID | type | careInstructions |
|---|---|---|
| 1 | Rose Bushes | Water regularly, prune dead leaves. |
| 2 | Tomatoes | Keep well-watered but not overly saturated, provide ample sunlight. |
| 3 | Pansies | Easy to grow, requires full sun and moist soil. |
| 4 | Tulips | Prefer cool weather, plant bulbs in fall for spring blooms. |
| 5 | Lavender | Needs well-draining soil, avoid overwatering. |
| gardeningClubID | plantID |
|---|---|
| (→ Gardening_Clubs.clubID) | (→ Plants.plantID) |
| 1 | 1 |
| 2 | 1 |
| 3 | 1 |
| 4 | 1 |
| 5 | 1 |
| memberID | firstName | lastName |
|---|---|---|
| 1 | John | Smith |
| 2 | Jane | Doe |
| 3 | Alice | Brown |
| 4 | Bob | White |
| 5 | Emma | Black |
| eventID | title | description | date |
|---|---|---|---|
| 1 | Spring Planting Party | Celebrate the beginning of Spring! | 2021-03-20 |
| 2 | Summer Bloom Festival | Show off your garden's best blooms. | 2021-07-10 |
| 3 | Autumn Leaf Raking | Get ready for winter by raking leaves. | 2021-10-01 |
| 4 | Winter Pruning Workshop | Learn how to properly prune plants for next year. | 2021-12-12 |
| 5 | Annual Seed Swap | Exchange seeds and gardening tips with fellow members. | 2022-02-20 |