I don't have a sample script I'm afraid, currently this is being done in C#. Seems rather silly to me to load an entire casenote from the database, convert...

I deal with health data, and for some reason people get really upset when you stick a bloke on a bedpan in the middle of a ward full of women....

GSquared (3/2/2010)

Very few things in this world are as cut-and-dry in data modeling as many people would like to think. Even gender is complicated by things like California laws...

I find it very hard to teach normalisation due to the poor examples in a number of textbooks. If people use a bad one they can confuse themselves horribly,...

It depends on what your understanding of publisher_city actually is. For an attribute to be functionally dependant on another attribute (lets use P and C, for publisher and publisher_city)...