Before I start filling out it, I thought it would be good to ask some people’s s opinions to know if I am following the correct path or if I should try another way.
Imagine I have a database for a farm, I would like to try to organize the tasks that are performed there, including the inputs/products used to perform each task.
Which one is the best path to follow and track in the future? (Feel free to suggest an alternative.)
First table: Tasks (with linked record to the second table).
Second table: Inputs / Products.
(Every time I use a product I create a new record with its respective quantity, the unit of measure, price, purchase date, etc. even if an identical product has already been used).
First table: Tasks (with linked record to the third table).
Second table: Catalog of Inputs / Products (category, type, length, weight etc).
Third table: Inputs / Products used (with linked record to the second table specifying the quantity of the product used).
(I don’t know if the second option makes sense at all I just thought it could be a way to make data more clear and in the long term have a catalog of products so I have to fill less information, for example, If the product is already in the catalog, I just have to link it and fill the price it was paid, the purchase date and attach the files relate to it - warranty etc.).
I appreciate any contribution!
Thank you for your help and attention!
I’m sorry for any inconvenience.
- First option
- Second option
- None / I replied with a suggestion