Note: "Setting Matters Straight" (SMS) is a new format: I post on LinkedIn an online Q&A involving data fundamentals that I...

  Note: "Setting Matters Straight" is a new format: I post on LinkedIn an online Q&A involving data fundamentals to encoura...

 “A data model is a collection of concepts ... used to describe the structure of a database...data types, relationships and constraints...is...

One of the core objectives of this site (and my work) has been to demonstrate that there will not be progress in data management as long as ...

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

Note: To demonstrate the correctness and stability due to a sound theoretical foundation relative to the industry's fad-driven "co...

“To Normalize or not to Normalize? that really isn't a question. few things to consider: Normalization is supposed to protect from data ...

Each "Test Your Foundation Knowledge" post presents one or more misconceptions about data fundamentals. To test your knowledge, fi...

Each "Test Your Foundation Knowledge" post presents one or more misconceptions about data fundamentals. To test your knowledge,...

“RDBMS stands for Relational Database Management System. RDBMS is the basis for SQL, and for all modern database systems like MS SQL Server...

Note: This is a re-write of a previous post. "I have a database for a school ... [with] numerous tables obviously, but consider th...

Note: This is a re-write of older posts (which now link here), to bring them into line with the McGoveran formalization, re-interpretation...

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

“What is the difference between an index and a key? How are they related?” “There seams to be some confusion between what a Primary Key ...

8/18/18: I have re-written this post for a better explanation. If you read it prior to the revision, you should re-read it.   “I learned...

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

“A short time ago a colleague asked me where he could find a "Databases 101" guide for the non-technical professional. As it tur...

(See Part 1 and Part 2 ) “A common term used in database design is a "relational database" -- but a database relation is not ...

Note: This the third of three re-writes of older posts to bring them in line with McGoveran's formalization and interpretation[ 1 ] of ...

Note: This is a rewrite of older posts (which now link here), to bring them into line with the McGoveran formalization and interpretation [...