Gardening_Clubs

clubIDnamelocation
1Sunshine GardenersNew York
2Green Thumbs SocietyLos Angeles
3Floral FriendsChicago
4Blossom BunchMiami
5Nature LoversDallas

Plants

plantIDtypecareInstructions
1Rose BushesWater regularly, prune dead leaves.
2TomatoesKeep well-watered but not overly saturated, provide ample sunlight.
3PansiesEasy to grow, requires full sun and moist soil.
4TulipsPrefer cool weather, plant bulbs in fall for spring blooms.
5LavenderNeeds well-draining soil, avoid overwatering.

Gardening_Clubs_Plants

gardeningClubIDplantID
(→ Gardening_Clubs.clubID)(→ Plants.plantID)
11
21
31
41
51

Members

memberIDfirstNamelastName
1JohnSmith
2JaneDoe
3AliceBrown
4BobWhite
5EmmaBlack

Events

eventIDtitledescriptiondate
1Spring Planting PartyCelebrate the beginning of Spring!2021-03-20
2Summer Bloom FestivalShow off your garden's best blooms.2021-07-10
3Autumn Leaf RakingGet ready for winter by raking leaves.2021-10-01
4Winter Pruning WorkshopLearn how to properly prune plants for next year.2021-12-12
5Annual Seed SwapExchange seeds and gardening tips with fellow members.2022-02-20