Data Modeling: It's All About the Relationships

This Bert Scalzo white paper covers common data modeling mistakes due to the complexities involving relationships and their corresponding foreign keys.  Throughout the paper, the author gives examples of tables and code to illustrate his points.

This is the second in a series of data modeling white papers, including Data Modeling: Common Mistakes and their Impact and Data Modeling: Reality Requires Supertypes and Subtypes.