DATABASE DEBUNKINGS
Monday, March 23, 2020

TYFK: How (Not) to Compare NoSQL Systems and RDBMSs

›
Note: About TYFK posts (Test Your Foundation Knowledge) see the post insert below. “But if you still want to compare NOSQL databases wit...
Thursday, March 12, 2020

Muddling Modeling Part 2: An Example

›
In an old article I used a Hay-Ross exchange to illustrate how disregard for fundamentals and the associated name proliferation -- which un...
Sunday, March 1, 2020

Muddling Modeling Part 1: Fundamentals

›
“Data modelling, star schema, snow flakes, data vault. Implementing virtual data warehouses (many stage to modify relationships). Normalis...
Friday, February 14, 2020

TYFK:What Is a Relational Schema?

›
Note: About TYFK posts (Test Your Foundation Knowledge) see the post insert below. “A relational database stores information in a structu...
Wednesday, February 5, 2020

Re-write

›
See: What Is A Database Relationship
Thursday, January 30, 2020

TYFK: What Is a Relational Database?

›
“RDBMS stands for Relational Database Management System. RDBMS is the basis for SQL, and for all modern database systems like MS SQL Server...
Friday, January 24, 2020

Naming Relations: Singular or Plural?

›
Note: Revised 1/24/20. “There is a lot of confusion when it comes to designing tables in SQL Server around whether to pluralize names or ...
‹
›
Home
View web version
Powered by Blogger.