-
A Lexicon of Bad Database Designs – Another Call for Participation
Last October, I published a call on this website for participation and feedback regarding a nonstandard book on data modeling and database design that I am working on. One of its nonstandard aspects is what I informally call a Lexicon of Lethal Database Designs: real-world design errors that have resulted in derailed—or even failed—IT projects,…
-
Relational or Logical?
When you’re talking about tables, columns, and foreign keys in the context of a database, you are typically modeling both a relational model and a logical model, and there is a distinction between the two: In summary, the relational model is a theoretical framework that defines the fundamental concepts of how data should be organized…