Monthly Archives: September 2016

Optional one-to-one relationships (#8)

By |2018-03-26T12:39:02+11:00September 22nd, 2016|Newsletter|

Optional one-to-one relationships Optional one-to-one relationship are more common than mandatory one-to-one relationships, both in life and in data modelling. Sometimes an object may be optionally connected to at least one other object. One example is a car, which may be registered or licensed for use on the road or it may be allowed to [...]

Connections (#6-7)

By |2018-03-26T14:02:50+11:00September 16th, 2016|Newsletter|

Types of connections Connections are the most important and difficult things in modelling. Objects only rarely exist with no connections to other objects. The saying “No man is an island”[1] expresses this with regard to people, and other objects are just the same. […]

Simple Data Modelling Example – Table Columns (#5)

By |2017-11-22T14:12:33+11:00September 1st, 2016|Newsletter|

In this article we continue our simple data modelling example.  We have named our database table, and now we need columns to store the information about each pot. Naming columns is another minefield, just like naming tables. All sorts of logic can be applied to avoid naming conflicts and ensure consistency. We will ignore this [...]

Go to Top