How would you organise this? (Rating for Destination per Level per Month)

So I have this dataset and I’m really struggling to find the way to organize my data Types, Fields and Relationships.

It’s a Score (1 to 5) to show if a Destination is good to go depending on your Experience and Month you want to go.

Ultimately I want people to be able to sort/filter these destinations by Experience and Month among other filters (budget, weather, etc.).

I don’t think adding 36 fields to the Type Destination is the best way to do it.

Also, it needs to be flexible if I want to make changes to my database. I’ve read about normalization and data base design but this one is beyond me…

Please send help.

Maybe …

Experience - (with beginner / intermediate etc)
Month - Text (with Jan/Feb/Mar etc)

Score

Score - Number
Experience - Experience
Month - Month

1 Like

ok, and then the Destination has a Score which will depends on the Experience and Month I have in Inputs

Destination
Name (text)
Score (Score, Experience, Month)

I am right?

But Experience and Month don’t make a Score… Score depends on the Destination as well, no?

Ah, yes.

Destination - you destinations
Experience - (with beginner / intermediate etc)
Month - Text (with Jan/Feb/Mar etc)

Score

Score - Number
Experience - Experience
Month - Month
Destination - Destination