Question about modeling election data

[leoarruizz]

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:

[rebeccarabb]

Hi leoarruizz,

This looks like a good start! I'm interested to know more about what kind of questions you're trying to answer with this graph. Is there some particular query that's taking a long time to run or additional questions you have on elections where you're not quite getting what you need from this schema?

Best,
Rebecca