An experimental forest, which is identified by its name, has many trees of various species. Data about the forest's size, owning company, and location is to be maintained by the database. A forest is maintained by foresters, who are uniquely identified by their SSN. A forester only maintains one forest. Also, the foresters' name, age, and address is to be captured. The experimental forest contains data about each species. A species is uniquely identified by its name. In addition, the woodtype and maximum height for the species is maintained. Trees in the forest are identified by their tree number. Also, the tree's location and date planted is maintained. The tree's species is also captured. The trees in the experimental forest will be measured several times during the tree's life span, and each measurement will have a unique number. The measurement result, type, and date is also maintained. Trees can propagate more trees, and the same data must be captured for the child trees.
Tags: