Design Challenge Collection

A great way to sharpen our analysis and modeling skills is to continuously address real-world scenarios. The scenario is emailed to more than 3,500 data management practitioners up to the challenge. Many of the responses, including my own, are then consolidated into an article. These articles will be published in leading trade journals such as Information Management and The Data Administration Newsletter (TDAN.com). If you would like to join our group and receive these modeling puzzles, please add your email address below.

1	Having the same primary key in two or more logical entities
2	Create a logical data model?
3	Convincing project teams of the need to normalize
4	Techniques in reviewing a data model
5	Technical questions asked during a job interview for a data-related position
6	Taming the wild west modeler
7	We live in a world of classifications
8	Define a "Thing"
9	A tough rule
10	A Permission Puzzle
11	A Recursive Riddle
12	Logical Data Modeling in practice
13	Enterprise Data Model ROI
14	The Person Identifier
15	Medals for Model Layout
16	To surrogate key or not to surrogate key, that is the question
17	Global Address
18	Dimensional logical?
19	Aggregation, summarization, and abstraction demystified
20	Decoding codes
21	Role of the data architect
22	Getting physical with subtypes
23	Creative hierarchy
24	Definition Differences
25	Super Star
26	Rules on rules
27	Data Dictionary, are you out there?
28	Null AK?
29	Broken shells
30	Recursive fact table?
31	A Dimensional EDM
32	Thinking Data
33	Timeless Dimensional Model
34	Subtype key
35	Customer Id
36	Ontology and Taxonomy
37	Product Availability
38	The Spam Model
39	Canonical Data Model Defined
40	Is GUID good?
41	Business intelligence?
42	What's a good name for the high level model?
43	AAs vs. DAs
44	As low as you can go
45	My Hero Zero
46	Data becoming Metadata
47	Producing Adequate Definitions
48	Swimming in Rough Water
49	Is Cost a Fact?
50	Where does XML fit?
51	Recycle, Reduce, Reuse
52	Agile Enterprise Data Modeling,  an oxymoron?
53	Data Modeling in the Cloud
54	Who owns the data model?
55	How long will the modeling take?		Coming soon!
56	SCD Type 3 for me?		Coming soon!