Now we are potentially getting right in amongst the weeds and many a data model gets stuck in the weeds because this issue is not understood.
data modelling
What makes a good datamodel?
Trying to model humans is probably the easiest way I know to break an inflexible model. Why? Because humans are recursive – that means they keep repeating the same thing and also they keep changing the rules! Humans start off as a child and become parents, they form relationships with each other, they marry each other and they can now change gender. If you designed your database schema in the 1500’s you would have had to rebuild it several times since!
