Thanks for this Alex. It was informative however I found when trying to build the database following your template gave me more questions.
I have the basic tables set out as you have shown. I have entered the basic ingredients into the ingredients table. I am in the process of entering the quantities into the measurement_qty table and can't help feeling as though I am going down the wrong road as the measurements units table, so far, is redundant.
Thanks for any help/assistance or pointers you can give.
So after reading theabove several times I have entered the cups/packet etc into the measurement_units table and the qty_amount, 1, into the measurement quantity table but still feel I am missing something to tie all the tables together.
I have PK and FK setup but not 100% sure on whether I have done it correctly.
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
Thanks for this Alex. It was informative however I found when trying to build the database following your template gave me more questions.
I have the basic tables set out as you have shown. I have entered the basic ingredients into the ingredients table. I am in the process of entering the quantities into the measurement_qty table and can't help feeling as though I am going down the wrong road as the measurements units table, so far, is redundant.
Thanks for any help/assistance or pointers you can give.
So after reading theabove several times I have entered the cups/packet etc into the measurement_units table and the qty_amount, 1, into the measurement quantity table but still feel I am missing something to tie all the tables together.
I have PK and FK setup but not 100% sure on whether I have done it correctly.