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.