medication database

[sid]

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)

 

[John Vinson]

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 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!

 

[Support & Design]

I am from the support department at http://www.enterpriseprojectconsulting.com and we would b

happy to assist you in resolving your issue

Thank you

Enterprise Project Consulting