Showing posts with label 1NF. Show all posts
Showing posts with label 1NF. Show all posts
Friday, October 13, 2023

EVERYBODY THINK THEY KNOW FIRST NORMAL FORM, BUT NOBODY DOES

›
“I have read this article in an effort to boost my academic knowledge on data modeling a bit and still have no idea what this academic autho...
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...
Thursday, November 3, 2022

NOBODY UNDERSTANDS NORMALIZATION 3 (sms)

›
09/19/23: For the latest on 1NF see : FIRST NORMAL FORM - A DEFINITIVE GUIDE   Note: In "Setting Matters Straight" posts I deb...
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...
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...
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...
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...
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...
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 ...
Thursday, November 11, 2021

Nobody Understands the Relational Model: Semantics, Relational Closure and Database Correctness Part 2

›
 with David McGoveran  (Title inspired by Richard Feynman) In Part 1 we explained that all database relations are, mathematically, relation...
Wednesday, October 27, 2021

Nobody Understands the Relational Model: Semantics, Relational Closure and Database Correctness Part 1

›
 with David McGoveran  (Title inspired by Richard Feynman) “As currently defined, relational algebra produces anomalies when applied to non-...
Sunday, September 19, 2021

TYFK: Calculated Attributes -- Redundancy, Full Normalization and Relational Theory

›
Note: Each "Test Your Foundation Knowledge" post presents one or more misconceptions about data fundamentals. To test your knowle...
Tuesday, August 31, 2021

TYFK: Normalized, Fully Normalized, Non-Normalized, Denormalized -- Clearing the Mess

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

RE-WRITE

›
See: https://www.dbdebunk.com/2023/08/entities-properties-and-codds-sleight.html
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...
Friday, February 12, 2021

TYFK: What Is a Relational Database and Why Is It Important?

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

Normalization -- Will They Ever Learn?

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

Understanding Codd's 12 Rules for RDBMS

›
In response to an online publication of a book appendix regurgitating Codd's 12 famous rules (some of which were, typically, incorrect[ ...