Archive for December, 2008

Many to Many Relationships

Wednesday, December 31st, 2008

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.

(more…)

Installing the free edition of Visual Paradigm

Monday, December 29th, 2008

How to install Visual Paradigm community edition

vp_download_ceWhile 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 community edition that can be downloaded for personal use. The Community Edition page has a link on the left hand-side to download Visual Paradigm.

(more…)