medication database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I like to would like to design a table for medications and need help any help I can get to make it very stable.
I am new to database, and have limited knowledge so please provide more details if you like to help.

Patient prescriptions (multiple prescriptions for each patient)
GenericName (single)
TradeName (can be multiple for the same GenericName)
Dosage (can be multiple for each TradeName)
Form (multiple for each TradeName)
 
I like to would like to design a table for medications and need help any help I can get to make it very stable.
I am new to database, and have limited knowledge so please provide more details if you like to help.

Patient prescriptions (multiple prescriptions for each patient)
GenericName (single)
TradeName (can be multiple for the same GenericName)
Dosage (can be multiple for each TradeName)
Form (multiple for each TradeName)
Click to expand...

I can see at least SIX tables here: Patients; Medications;
Manufacturers; Tradenames; Dosages (incorporating form and dosage
level); Prescriptions.

One thing to consider is that any such database would be required to
comply with the very complex HIPAA patient-privacy regulations. In
addition, as you know, this could have life-or-death consequences -
for some meds, 1 mcg/kg/day might be lifesaving and 1 mg/kg once might
be promptly fatal. You may want to hire someone experienced in such
applications, to be safe!

This can be done... you can probably do it yourself - but you'll need
to be very, very through and careful!
 
Back
Top