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

OBG: Data Warehouses Are Non-Relational Application Views

›
Note: To demonstrate the correctness and stability due to a sound theoretical foundation relative to the industry's fad-driven "...
Saturday, September 4, 2021

Understanding Relational Constraints

›
“The data in a relational database is stored in form of a table. A table makes the data look organized. Yet in some cases we might face issu...
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...
Friday, August 13, 2021

OBG: The Myth of Market-Based Education

›
(Originally posted on 09/08/2001, slightly revised) Note: To demonstrate the correctness and stability due to a sound theoretical foundatio...
Thursday, August 5, 2021

TYFK: Facts, Properties, Relationships, Domains, Relations, Tuples

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

Documents and Databases

›
'These new data technologies were developed because there are new usage scenarios for data — which do not fit into the relational model....