In our last design challenge we agreed that we should normalize regardless of database platform, and we discussed a... There are a number of techniques I apply when I review a data model. Using these techniques over the... I was very recently teaching a data modeling course and decided to make the normalization section a bit more... When I tell folks about these design challenges, I sometimes receive comments like “So you get other people to... Let’s assume your organization has a globally agreed upon definition of a classification: “A way of grouping similar items... Trends towards integration in our organizations naturally lead to more abstract concepts. It is not uncommon for example, to... The model below is from an actual project (with the subject matter changed to protect the innocent entities): The... Based on a challenge submitted by Ben Ettlinger – thanks Ben!We are building a web application that will allow... I am cheating just a bit with this challenge, as this is one of the ones from my new book... The Logical Data Model (LDM) is a model showing the rules behind how something works independent of context. Context...Blogs
Convincing project teams of the need to normalize
Techniques in reviewing a data model
Technical questions asked during a job interview for a data-related position
Taming the wild west modeler
We live in a world of classifications
Define a “Thing”
A tough rule
A Permission Puzzle
A Recursive Riddle
Logical Data Modeling in practice
1
0