with David McGoveran   Note: This a multi-part re-write of a previous series intended, when completed, to replace it. In the meantime you ca...

Note: In "Setting Matters Straight" posts I debunk online pronouncements that involve fundamentals which I first post on Linked...

Note: Each "Test Your Foundation Knowledge" post presents one or more misconceptions about data fundamentals. To test your know...

Note: This is a re-write of an earlier post. About TYFK posts (Test Your Foundation Knowledge) see the post insert below. “Here two or ...

Ass ume a conceptual model of a multigroup consisting of two related entity groups, Customers and Orders, where a customer can issue multi...

In Part 1 we presented some foundation knowledge with which to debunk misconceptions lurking in the industry's "data modeling...

In Part 1 we presented some foundation knowledge with which to debunk misconceptions lurking in the industry's modeling mess that Frie...

Part 1 outlined fundamentals of fourth order properties (4OP) of a multigroup arising from relationships among its group members due to 1:...

  “We have Building, Room, and Bed entities. Logically, if this is in the scope of some hypothetical hotel, then each one of those entitie...

“The choice of good InnoDB primary keys is a critical performance tuning decision. This post will guide you through the steps of choosing ...

Note: This is the second part of a multipart re-write of several older posts to bring them into line with the McGoveran formalization and r...

Note: This is the first part of a two-part re-write of several earlier posts, to bring them into line with McGoveran's formalization an...

The data management field cannot and will not progress without educated and informed users. Recently I announced UNDERSTANDING THE REAL RDM,...

"I have two tables, one is product which is a parent table with one primary key and I have another child table of product, which is...