You are a data modeler designing a data mart, and have come across at least two different entities on... You are a data modeler creating the design for a non-relational database. “Non-relational” means the underlying database does not... 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...Blogs
Having the same primary key in two or more logical entities
Create a logical data model?
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
1
0