When normalizing data structures, attributes congregate around the business keys that identify the grain at which those attributes derive their values. Attributes directly related to a person, ...

When the healthcare industry talks about data, the conversation usually focuses on interoperability and data standards. These are certainly important topics, but they don’t fully address the challenge ...

I have an order table that is an order for a customer. I need to reference as a foreign key an unknown number of products that could make up the order (product_id) how do I do this? What am I missing.

Many people seem to become filled with anxiety over the word “normalization.” Mentioning the word causes folks to slowly back away toward the exits. Why? What might have caused this data modeling ...

Good software habits apply to databases too. Trust in these little design tips to build a useful, rot-resistant database schema. It is a universal truth that everything in software eventually rots.