search

fac-13 / HEII-topics

website where you can log in, post topics and vote on topics
https://heii-voting-topics.herokuapp.com/
2 stars 1 forks source link

Ambitious! #15

Open missKatiaPunter opened 6 years ago

missKatiaPunter commented 6 years ago

Great ER diagram, well done.

missKatiaPunter commented 6 years ago

However, the fact that your topic has user ID bothers me. Have you considered researching whether it is needed? It does not look normalised to me.

missKatiaPunter commented 6 years ago

Read up on transitive dependencies and the need of their removal to reach the third normal form. But, I am not 100% sure I am right.

missKatiaPunter commented 6 years ago

I would even say vote is a field in topic, not its own entity. then one user can only vote ones for one topic