Please draw both the Entity Relationship Diagram and Schema as I am trying to learn how to convert an ERD to a Schema.

The current answer on Chegg for a similar question is incorrect. There should be a total number of 6 tables in the schema which is including the added table between gardener/garden and the added table between garden/flower.

I will upvote if correct, thank you.

We are designing a database for Garden management where Garden, Flowers, Wells and Gardeners are the entities. Right now, we only know that each entity has an ID attribute. Draw a Schema for this database (you might need to draw an ERD too) and then answer the 4 questions that follow: A Flower should grow in at least one Garden. A Garden may grow 0 or more Flowers. A Well will supply water to many Gardens. A Garden will be supplied water through only 1 Well. A Gardener should take care of at least 1 Garden. A Garden can be cared for by at most 2 Gardeners