Showing posts with label 5NF. Show all posts
Showing posts with label 5NF. Show all posts
Monday, June 19, 2023

PREDICATE LOGIC, SEMANTICS AND RDM (sms)

›
Note: In "Setting Matters Straight" posts I debunk online pronouncements that involve fundamentals which I first post on Linked...
Sunday, May 28, 2023

INTENSION, EXTENSION AND R-TABLES (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 23, 2023

THE DENORMALIZATION ILLUSION (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 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...
Saturday, April 8, 2023

MISSING DATA: RDM VS SQL -- A REAL WORLD COMPARISON (t&n)

›
Note: "Then & Now" (t&n) is a new version of what used to be the "Oldies but Goodies" (OBG) series. To demonstra...
Saturday, March 4, 2023

ON NORMALIZATION AND THE SCIENTIFIC METHOD (t&n)

›
(originally published August 2002) Note: "Then & Now" (T&N) is a new version of what used to be the "Oldies but Go...
Sunday, January 22, 2023

CONCEPTUAL BUSINESS RULES AND LOGICAL CONSTRAINTS (sms)

›
Note: In "Setting Matters Straight" posts I debunk online pronouncements that involve fundamentals which I first post on Linked...
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...
Sunday, October 23, 2022

NOBODY UNDERSTANDS NORMALIZATION 2 (sms)

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

NOBODY UNDERSTANDS DATABASE DESIGN 1 (sms)

›
Note: In "Setting Matters Straight" posts I debunk online pronouncements that involve fundamentals which I first post on Linked...
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...
Thursday, August 4, 2022

DATABASE RELATIONS, TABLES AND SEMANTIC CONSISTENCY

›
by David McGoveran with Fabian Pascal   Note: In "Setting Matters Straight" posts I debunk online Q&As that involve fundament...
Sunday, June 26, 2022

REPEATING GROUPS AND 1NF (t&n)

›
09/19/23: For the latest on this subject see : FIRST NORMAL FORM - A DEFINITIVE GUIDE   “A commonly used example of a table that is not i...
Saturday, May 21, 2022

NO RDBMS WITHOUT RELATIONAL DOMAINS (obg)

›
Note: To demonstrate the correctness and stability due to a sound theoretical foundation relative to the industry's fad-driven "...
Monday, May 2, 2022

RELATION PROLIFERATION (sms)

›
Note: "Setting Matters Straight" is a new format: I post on LinkedIn an online Q&A involving data fundamentals that I subse...
Monday, April 25, 2022

RELATIONAL DATABASES & SET THEORY (sms)

›
Note: "Setting Matters Straight" is a new format: I post on LinkedIn an online Q&A involving data fundamentals that I subse...
Saturday, January 1, 2022

SCHEMA & PERFORMANCE: NEVER THE TWINE SHALL MEET

›
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 ...
Saturday, December 11, 2021

NOBODY UNDERSTANDS THE RELATIONAL MODEL: SEMANTICS, CLOSURE & CORRECTNESS PART 4

›
with David McGoveran (Title inspired by Richard Feynman) In Parts 1 and Part 2 we provided some clarifications following a discussion on L...
Sunday, December 5, 2021

HOW NOT TO EXPLAIN THE RELATIONAL MODEL (tyfk)

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