Hello everyone, I'm glad to be part of this community.
I'm currently working on a project in which I have to make a model of an election, not only one election but for each one that happens in 4 years.
Currently, I have modeled four entities: the candidate, the election, the municipality, and the state. As for the relationships, I think that the model that I made might be a bit redundant because I'm storing the votes on each relation and, I end having a lot of relationships: each candidate x municipality, and the queries might have a slow execution time.
I think that this model might not be optimal, or maybe my queries are the ones that are not optimal. Besides, if you have any suggestions, I'll gladly take them.
Thanks.
The model: