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.
NigelG
2
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?
NigelG
5
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