-
Having the same primary key in two or more logical entities
You are a data modeler designing a data mart, and have come across at least two different entities on...
10 -
Create a logical data model?
You are a data modeler creating the design for a non-relational database. “Non-relational” means the underlying database does not...
-
Convincing project teams of the need to normalize
In our last design challenge we agreed that we should normalize regardless of database platform, and we discussed a...
-
Techniques in reviewing a data model
There are a number of techniques I apply when I review a data model. Using these techniques over the...
-
Technical questions asked during a job interview for a data-related position
I was very recently teaching a data modeling course and decided to make the normalization section a bit more...
-
Taming the wild west modeler
When I tell folks about these design challenges, I sometimes receive comments like “So you get other people to...
-
We live in a world of classifications
Let’s assume your organization has a globally agreed upon definition of a classification: “A way of grouping similar items...
-
Define a “Thing”
Trends towards integration in our organizations naturally lead to more abstract concepts. It is not uncommon for example, to...
-
A tough rule
The model below is from an actual project (with the subject matter changed to protect the innocent entities): The...
-
A Permission Puzzle
Based on a challenge submitted by Ben Ettlinger – thanks Ben!We are building a web application that will allow...