Tag: data design
Table names - Singular or Plural
Earlier this morning I tweeted asking for a quick idea of whether to go with singular table names or plural table names. i.e. the difference between having a...
Creating Many-to-Many joins
A topic that comes up from time to time in forums is how to join two tables together when there is a many-to-many relationship. Typical examples include...
Normalising the data model
Sometimes I see on forums someone who is trying to get some SQL statement to wield data in a particular way but the data model is just thwarting their...
The Normal Forms of Database Normalization
I'm doing a clear out at the moment as I'm getting the house ready to sell - I'm planning to move to West Lothian - and I came across some old notes about...
Delete the row, or set a deleted flag?
For auditing purposes some database system run without deleting rows from the database - they just flag the row as being deleted and ensure that queries that...
