We are designing a database for Garden management where Garden, Flowers, Vegetables, 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.

1) What is the total number of tables in the Schema for the Garden Management database described above ?

2) Which of the following relations do not require a separate table to be created in the Schema?

(a) Garden in relation to Flower

(b) Well in relation to Garden

(c) Garden in relation to Gardener

(d) None of these

(e) All of these

(3) Which of the following relations require a separate table to be created in the Schema?

(a) Well in relation to Garden

(b) Garden in relation to Flower

(c) Garden in relation to Gardener

(d) Gardener in relation to Flower

(e) All of these

(f) None of these

(4) What is the total number of tables in the Schema for the Garden Management database described above?