A great way to sharpen our analysis and modeling skills is to continuously address real-world scenarios. A modeling scenario along with suggested solutions will appear each month in DM Review magazine. The scenario is emailed to more than 2,500 modelers up to the challenge. Many of the responses, including my own, are then consolidated into this column. If you would like to become a design challenger and have the opportunity to submit modeling solutions, 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		Coming soon!
39	Canonical Data Model Defined		Coming soon!
40	Is GUID good?		Coming soon!