Quote:
Originally Posted by hektisk
Details of what? I apologize - I don't mean to be obtuse. We would store no data except for their name on the hospitals and doctors in this database. So we wouldn't, for example, store the doctor's address or the hospital's phone number. I'd plan on creating a lookup with fixed values (drop-down box) to ensure consistency. If I were to create new tables for hospitals and doctors, why would I not create tables for every other column which has a pre-set number of options (such as the wounds or infections columns)?
|
Well, if you're planning "on creating a lookup with fixed values (drop-down box) to ensure consistency", that's a definite candidate for a table in its own right. I imagine your 'catchment' in this regard is for the most part fairly limited, so the number of entries to go into and be maintained in the table would be relatively small.
And, yes, you could create another look-up table for 'conditions' but I imagine there'd be so many variations compared to the number of patients that the effort in creating and maintaining it would outweigh the potential benefits.