Hi there,
Many of you might already be familiar with my amateur questions regarding the database I'm currently developing for our medical research group.
We are working at a neonatology ward, an intensiver care unit for newborns. These babies recieve continuous hourly physiological monitoring, infusions/drugs, respirating and frequent test (blood, US, etc.) for their first week of life.
My current problem is with recording the continuous variables, like infusions. A sample data for one patient would look like this:
Morphine infusion started at 15:00 on 15/11/2011, and the speed is recorded in the documentations every hour, until it is stopped at 18:00 on 18/11/2011. (There is a big printed spreadsheet for each day and each baby, columns correspond to hours, rows to infusions). The speed of the infusion might be changed a few times while it's running.
Originally I thought about making tables for each drug, where the fields would correspond to hours. This is probably not the best way to do it, regarding normalization, but I can't figure out a better one.
If anyone had any constructive ideas, I would really appreciate it.
Thanks a lot,
Aron
Many of you might already be familiar with my amateur questions regarding the database I'm currently developing for our medical research group.
We are working at a neonatology ward, an intensiver care unit for newborns. These babies recieve continuous hourly physiological monitoring, infusions/drugs, respirating and frequent test (blood, US, etc.) for their first week of life.
My current problem is with recording the continuous variables, like infusions. A sample data for one patient would look like this:
Morphine infusion started at 15:00 on 15/11/2011, and the speed is recorded in the documentations every hour, until it is stopped at 18:00 on 18/11/2011. (There is a big printed spreadsheet for each day and each baby, columns correspond to hours, rows to infusions). The speed of the infusion might be changed a few times while it's running.
Originally I thought about making tables for each drug, where the fields would correspond to hours. This is probably not the best way to do it, regarding normalization, but I can't figure out a better one.
If anyone had any constructive ideas, I would really appreciate it.
Thanks a lot,
Aron