Data Modelling relationships between tables
The thing that got me writing this article was a question posted on Stack Overflow about data design, asking whether it’s better to use one big table or to arrange the data using multiple related tables. Having spent many years working with relational databases this seems obvious, it’s easy to forget this is not common knowledge and assume everyone knows this stuff.
While writing an article on implementing Many to Many Relationships in databases the need for a diagramming tool became clear. At work Visual Paradigm is the tool for all UML and data modelling requirements, so it was good to read there is a free