How should I setup this database?

alexander2 · 2020-06-19T15:51:00.102Z

Hey everyone!

I’m currently setting up my Wine database and I came across a problem. In my dataset a wine can have several grapes at different percentages. It looks like this:

Skjermbilde 2020-06-19 kl. 17.44.03972×762 43.3 KB

How would you solve this in a database structure? Normally I would just make a relationship to a grapes DB and link it that way, but I have the percentage here too… How would you do it?

SerPounce · 2020-06-19T17:20:11.266Z

My suggestion:
Add a table for grapes. This is a simple list of all the different types of grapes. You could also use an option set for this.
Then add an additional table for ingredients. This table would include at a minimum the following things:
Wine (lined to the wine table)
Grape (linked to the grape table or option set)
Percent