Link to home
Start Free TrialLog in
Avatar of Moe DeShong
Moe DeShongFlag for United States of America

asked on

Database table structure

I'm working on a program to track plants for a nursery and am having an problem structuring the database.  For each plant there can be multiple crops each year. Each crop is divided into different descriptors when its entered in inventory. (graft, size1, size2, etc...) As the plant grows it can be shifted from one descriptor to the next.  
 I need to be able to track by crop number and only use a descriptor once for the plant.  For example: Crop1, Crop2, Crop3...  Descriptor: size1   I need to be able to get a total count from all the plants that have a specific descriptor regardless of what crop its from.  
Right now I have a table for Plants, Crop, Inventory. Each Plant has multiple Crops, each Crop has multiple inventory records.  Portions of the crop may be pre-sold so the same descriptor could be used for two different inventory records with one being marked as pre-sold.
Avatar of ste5an
ste5an
Flag of Germany image

Gather the requirements first. Phrase them in simple, but correct language. Check whether they have errors or contain contradictions. Then
create a entity-relationship model from then. The last step is to derive the database model from the ER model.
Avatar of Moe DeShong

ASKER

Thanks for the comment.  I'm going to have to do a bit of research to figure it out. I'll get back.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.