BrianP03103

Here are the proposed Genera, Species, and Cultivars tables, the first two adjusted for the generation of the Cultivars table.

Note that the Species table does not presume the existance of a related Cultivars table record. It allows for such a record, but neither requires one nor presumes its existence. While both tables have many identical memo fields, none but Description is required in either table, giving the user the option of entering information in either (or both) tables, as they see fit.


Genera

GenusID (AutoNumber)
GenusBotanicalName (Text - 50)
GenusCommonName (Text - 50)
GenusDescription (Memo)


Species

SpecieID (AutoNumber)
GenusID (LongInteger)
SpecieBotanicalName (Text - 50)
SpecieCommonName (Text - 50)
SpecieDescription (Memo)
SpeciePositionLighting (Memo)
SpecieFertilizingWatering (Memo)
SpeciePruning (Memo)
SpeciePestsDiseases (Memo)
SpeciePropagation (Memo)
SpeciePhotoPath (Text - 255)


Cultivars

CultivarID (AutoNumber)
SpecieID (LongInteger)
CultivarBotanicalName (Text - 50)
CultivarCommonName (Text - 50)
CultivarDescription (Memo)
CultivarPositionLighting (Memo)
CultivarFertilizingWatering (Memo)
CultivarPruning (Memo)
CultivarPestsDiseases (Memo)
CultivarPropagation (Memo)
CultivarPhotoPath (Text - 255)

__________________

Advertisement