Showing posts with label SK. Show all posts
Showing posts with label SK. Show all posts
Monday, July 31, 2023

ON RELATIONAL KEYS (& DOMAINS) (t&n)

›
Note: "Then & Now" (t&n) is a new version of what used to be the "Oldies but Goodies" (OBG) series. To demons...
Friday, March 25, 2022

KEYS & INDEXES (sms)

›
Note: "Setting Matters Straight" is a new format: I post on LinkedIn an online Q&A involving data fundamentals to encourage...
Sunday, February 13, 2022

NO UNDERSTANDING WITHOUT FOUNDATION KNOWLEDGE PART 5: DEBUNKING AN ONLINE EXCHANGE 4 (obg)

›
Note: To demonstrate the correctness and stability due to a sound theoretical foundation relative to the industry's fad-driven ...
Saturday, March 2, 2019

Fourth Order Properties Part 1: Association Relations vs. Foreign Keys

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

A New Understanding of Keys Part 3: Surrogate Key Illusions

›
Note: This the third of three re-writes of older posts to bring them in line with McGoveran's formalization and interpretation[ 1 ] of ...
2 comments:
Sunday, April 22, 2018

A New Understanding of Keys Part 2: Kinds of Keys

›
Note: This the second of three re-writes of older posts to bring them in line with McGoveran's formalization and interpretation[ 1 ] of...
8 comments:
Sunday, April 15, 2018

A New Understanding of Keys Part 1: Primary Key Formal Mandate and Pragmatic Selection

›
Note: This the first of three re-writes of older posts to bring them in line with McGoveran's formalization and interpretation[ 1 ] of...
6 comments:
Saturday, April 7, 2018

Name the Relational Violation Part 2: Self-defeating Constraint

›
Note: This two part series is a rewrite of of an older post (which now links here), to bring it into line with the McGoveran formalization ...
Tuesday, March 27, 2018

Name the Relational Violation Part 1: Conditional Uniqueness Constraint

›
Note: This is a rewrite of of an older post (which now links here), to bring it into line with the McGoveran formalization and interpretati...
Sunday, February 11, 2018

The Key to Relational Keys - A New Understanding

›
Version 3 of paper #4 in the PRACTICAL DATABASE FOUNDATION series is now available to order here . The Key To Relational Keys: A New Unders...