Follow @DBDebunk Follow @ThePostWest

1. Database Truth of the Week

“… logic—is an analytical theory of the art of reasoning whose goal is to systematize and codify principles of valid reasoning. It has emerged from a study of the use of language in argument and persuasion and it is based on the identification and examination of those parts of language which are essential for these purposes. It is formal in the sense that it lacks reference to meaning. Thereby, it achieves versatility: it may be used to judge the correctness of a chain of reasoning (in particular, a “mathematical proof”) solely on the basis of the form (and not the content) of the sequence of statements, which make up the chain.” --R. R. Stoll

2. What's Wrong With This Database Picture?

"Constraints are categorized as follows:

• Domain integrity Constraints
• Entity integrity Constraints
• Referential integrity Constraints
• Not null
• Unique
• Foreign key
• Check
• Primary key

Constraints are always attached to a column not a table." --Daykar, SQL Constraints

3. To Laugh or Cry?

Question: "Can a database contain two identical records without a negative effect on the integrity of the database? Why or why not?"
Best Answer: "Sure, not an issue but it will mean you can get multiple hits for the same query. You have to take that into account in your program." --Identical records with Integrity (check all three answers)

 4. Publications

• Interpretation and Representation of Database Relations, the first paper in the new UNDERSTANDING OF THE REAL RDM series,  is available for ordering here.

• My book, THE DBDEBUNK GUIDE TO MISCONCEPTIONS ABOUT DATA FUNDAMENTALS is available to order here.

Reviews

• Craig Mullins
• Todd Everett
• Toon Koppelaars
• Davide Mauri

5. Oldies but Goodies

Schema, NoSQL & Database Management (presentation)

6. Housekeeping

I am overhauling the "And Now for Something Completely Different" (ANFSCD) section of the This Week posts.

• Indications of the demise of Western civilization will be posted at to The PostWest blog, with a link posted to ANFSCD;

• ANFSCD here will focus on the acceleration of the demise and dehumanization by malevolent corporate technology out of control.

7. Of Interest

• Choose SQL
• What's wrong with big data
• Godel's Loophole: Applying Logic to the Constitution

And Now for Something Completely Different

The Demise of Western Civilization

This week @The PostWest

The Technology Dystopia

• Sillicon Valley Is As Self-Destructive As "Communism" Was and "Capitalism" Is
• Will the High-Tech Cities of the Future Be Utterly Lonely
• Googling gives us answers—but deprives us of intelligence
• Amazon Wants to Put a Camera and Microphone in Your Bedroom
• Defend Against Brain Hackers Before It's Too Late
• AI programs exhibit racial and gender biases

Reality Check

AI could build new drugs faster than any human team, but No one really knows how AI algorithms do what they do

Upside Down and Backwards

Technology Takes from the Poor and Gives to the Rich

Note: I will not publish or respond to anonymous comments. If you want to say something, stand behind it. Otherwise don't bother, it'll be ignored.