Showing posts with label PK. Show all posts
Showing posts with label PK. Show all posts
Thursday, May 2, 2024

SMS: PRIMARY KEYS & INDEXES

›
I am working on entirely new papers (not re-writes) in the PRACTICAL DATABASE FOUNDATIONS series. I have already published two: THE FIRST NO...
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...
Sunday, April 30, 2023

RELATIONSHIPS AND THE RDM V2 Part 3: SEMANTIC CONSTRAINTS

›
Note: This is a multipart re-write of a previous series that, when completed, is intended to replace it. In Part 1 we documented the diffe...
Sunday, April 16, 2023

RELATIONSHIPS & THE RDM V2 PART 2: INTRA-GROUP RELATIONSHIPS

›
  Note: This is a multi-part complete re-write of a previous series which, when completed, is intended to replace it. In Part 1 we attribu...
Friday, December 2, 2022

NOBODY UNDERSTANDS FURTHER NORMALIZATION 4 (sms)

›
Note: In "Setting Matters Straight" posts I debunk online pronouncements that involve fundamentals which I first post on Linked...
Saturday, October 8, 2022

NOBODY UNDERSTANDS NORMALIZATION 1 (sms)

›
Note: In "Setting Matters Straight" posts I debunk online pronouncements that involve fundamentals which I first post on Linked...
Monday, September 12, 2022

DATABASE DESIGN: THE STATE OF KNOWLEDGE IN THE INDUSTRY

›
Can you identify all the fallacies and misconceptions in the following online exchange ? What is the elephant in the room? Q: “I have done d...
Saturday, August 20, 2022

DATABASE RELATIONS, DATABASE DESIGN & CORRECTNESS (sms)

›
Note: In "Setting Matters Straight" posts I debunk online Q&As that involve fundamentals which I first post on LinkedIn. Th...
Sunday, July 3, 2022

RELATIONS, DATABASE RELATIONS AND TABLES (sms)

›
Note: In "Setting Matters Straight" posts I debunk online Q&As that involve fundamentals which I first post on LinkedIn. Th...
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, March 6, 2022

RELATIONSHIPS: UNIQUENESS & ATTRIBUTE CONSTRAINTS (tyfk)

›
Note: Each "Test Your Foundation Knowledge" post presents one or more misconceptions about data fundamentals. To test your know...
Saturday, February 19, 2022

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

›
Note: To demonstrate the correctness and stability offered by a sound theoretical foundation (relative to the industry's fad-driven ...
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 ...
Friday, December 17, 2021

NO UNDERSTANDING WITHOUT FOUNDATION KNOWLEDGE PART 2: DEBUNKING A BOOK REVIEW (obg)

›
Note: To demonstrate the correctness and stability offered by a sound theoretical foundation (relative to the industry's fad-driven ...
Monday, May 10, 2021

TYFK: What Domains Are and Are Not

›
Note: Each "Test Your Foundation Knowledge" post presents one or more misconceptions about data fundamentals. To test your know...
Sunday, April 11, 2021

TYFK: Relations, Tables, and Semantic Consistency

›
Note: Each "Test Your Foundation Knowledge" post presents one or more misconceptions about data fundamentals. To test your know...
Friday, March 12, 2021

TYFK: Tables Can Visualize -- But ARE NOT -- Relations!

›
Note: Each "Test Your Foundation Knowledge" post presents one or more misconceptions about data fundamentals. To test your know...
Saturday, January 23, 2021

"Codd was wrong" and "You're teaching the gospel" Betray Lack of Foundation Knowledge

›
Note: I have documented and debunked these misconceptions so many times that I will no longer reference them -- the reader motivated to...
Thursday, August 20, 2020

TYFK: Relations, Tables, Domains and Normalization

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

OBG: Data Independence and "Physical Denormalization"

›
Note: I am re-publishing some of the articles and reader exchanges from the old DBDebunk (2000-06). How well do they hold up -- have indus...