Garden database design

I am trying to design a database which will track information about a
garden. I have several entities in mind so far, the most troublesome noted
below with some of the most important attributes.

PurchaseInfo:
PurchaseIdNo (PK)
Supplier
DatePurchased
TypePurchase (which would contain one of the following items[Plant, Seed,
Misc])
.....

This is where the problem arises. Depending on the data in the TypePurchase
field, one or more things can happen:
1) If TypePurchase is Plant, it will go directly into the Garden as a
Planting (probably another entity containing information such as location,
number of plants, date planted etc.) It is possible (probable actually) to
set out different numbers of plants on different dates in different
locations.

2a) If TypePurchase is Seed, it could be either sown (planted) directly into
the garden where basically the same information as 1) above would need to be
tracked (again should be different numbers of seeds on different dates in
different locations)
2b) or it could be started inside where additional information will need to
be recorded (Light (light/dark), Heat (warm, cool), date sown, number seeds
sown, Transplant (y/n), if Transplant = y, number of transplants, date
transplanted). These seeds (which are now plants) will be planted into the
garden where they will require that the same information as in item 1) above
be recorded.

3) If the type is Misc, it does not go into the garden.

My problem is that I am unsure of the best way create the additional
entities to track the information about how the Seed information should be
recorded.

Thanks in advance for any help anyone can give me with this,
Hank


.

Relevant Pages

  • Re: High Cost of Seed Starting
    ... "Dan L." ... six small heating pads going to germinate my seeds. ... I am going to be stingy about using my heating pads next ... I do not have grow lights just designed for plants. ...
    (rec.gardens)
  • Re: Tomato seeds not germinating
    ... For the best chances of success, acquire your seeds from reputable ... As tomato seeds age, their germination rate decreases. ... Your choice of containers for potting up depends on the number of plants you ... You can plant lots of seeds close together because the resulting seedlings ...
    (uk.rec.gardening)
  • Re: Heated Propagator
    ... so I'm going to plant half the seeds as you've ... A heated propagator - even the cheapest basic model* without any thermostat ... *One thing to look out for is the lids. ... As has been pointed out by Mike Lyle, you will get unbalanced plants ...
    (uk.rec.gardening)
  • Re: Cannas in Kentucky?
    ... You can actually plant the plants deeper ... since you're already harvesting seeds. ... dig up the plants and put them two shovels deep into the same spot, ... problem and great success. ...
    (rec.gardens)
  • Re: Switzerland backs GM crop ban
    ... they produce infertile seeds. ... New Terminator Crops Coming ... The Br DAD1 gene is down-regulated with an anti-sense gene to Br ... achieve the density of plants required. ...
    (rec.travel.europe)