Saturday, May 11, 2024

L/C: TABLES, DIMENSIONS & RDM



 

Note: I am working on entirely new papers (not re-writes) in the PRACTICAL DATABASE FOUNDATIONS series. Two were already published:

THE FIRST NORMAL FORM - A DEFINITIVE GUIDE
PRIMARY KEYS - A NEW UNDERSTANDING

and are available for ordering from the PAPERS page.

One is in progress:

RELATIONAL DATABASE DOMAINS: A DEFINITIVE GUIDE

and two are forthcoming:

DATABASE RELATIONS: A DEFINITIVE GUIDE
THE FINAL NULL IN THE COFFIN - A RELATIONAL SOLUTION TO MISSING DATA

will be forthcoming.

In the process I come across matters that, while not includable the papers, are worthy of setting straight in brief posts here. Here is another:

“Data is stored in two-dimensional tables consisting of columns (fields) and rows (records). Multi-dimensional data is represented by a system of relationships among two-dimensional tables.” 

Thursday, May 2, 2024

My April FT, L/C & SMS Posts on LinkedIn



 

 

 

 

SMS: PRIMARY KEYS & INDEXES



Note: I am working on entirely new papers (not re-writes) in the PRACTICAL DATABASE FOUNDATIONS series. Two were already published:

THE FIRST NORMAL FORM - A DEFINITIVE GUIDE
PRIMARY KEYS - A NEW UNDERSTANDING

and are available for ordering from the PAPERS page.

Two more:

RELATIONAL DATABASE DOMAINS: A DEFINITIVE GUIDE
DATABASE RELATIONS: A DEFINITIVE GUIDE

are in progress.

In the process I come across matters that that are not included in the papers, but are worthy of setting straight in brief posts here. Here is one of them.

View My Stats