In today’s Adventures in Database Design, we’ll take a look at a relevant topic, ICD9 data. ICD9 data is the diagnosis and procedure codes used by insurance companies to categorize, well, diagnoses and procedures to be determined / performed by medical professionals. The design is simple, but very versatile, given the type of data we’re storing.

I’ve long neglected this blog, and the power behind it to discuss my feelings toward database design.  Proper database design is the backbone to a solid application.  Failing to correctly normalize tables and enforce business logic with foreign key relationships can cause undue headaches. What I’ll be doing is going through some simple applications, and […]