My June post @All Analytics Combining data extracts from databases for analytical purposes without knowing what the source database table...

The common and entrenched misconception about normalization was recently visible yet again in a LinkedIn exchange. R: Unless the need i...

I have corrected a mistake in For Codd's Sake : a mathematical relation is not the Cartesian product (CP) of the domains over which it...

See: Name the Relational Violation Part 1: Conditional Uniqueness Constraint

1. Quote of the Week Logical design is where the Architect defines entities (which will become tables in a database), attributes (which ...

May Post @All Analytics What you need to know for the purposes of this discussion is that tables that bundle multiple entity classes have...

1. Quote of the Week Codd's relational model is based on set theory, and set theory simply doesn't work for database systems. I...