How should I setup this database?

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:

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?

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)

1 Like