Normalization

  • Thread starter Thread starter jimmy0305
  • Start date Start date
J

jimmy0305

How can I separate the Diagnosis from the Medications
Medications & Diagnosis are based on a visit date....
which means that Diagnosis & Medications could change
in the next visit...

Right now, I put them together in one table... which I know is no
right...

I used to have repeating groups & I tried to fix it..
I'm trying to add a table for diagnosis but will still be
link to tblDiagMed... any Ideas

I really appreciate all the help...Thank

tblDiagMe
PatientI
Mx_I
VisitDat

tblDiagMed_Detai
Meds_ID<---Autonumber
Mx_I
Meds_Cod
Dosag
Diag_Cod

tblDrug
Meds_Cod
Des
Category_I

tblDiagnosi
Diag_Cod
Des
Category_I

Jim :
 
it's not clear just what you're trying to model. are you tracking diagnoses
and medications separately, as data directly linked to a specific patient
and office visit? or are the diagnoses linked to a specific patient/office
visit, and each medication in turn linked to a specific diagnosis? or the
opposite: the medications linked to a specific patient/office visit, and
each diagnosis in turn linked to a specific medication?

you need to clearly define the "real-world" relationships between the data
you need to store, before you can create a table structure to correctly
model those relationships. if you're not familiar with table
normalization/relationships, suggest you browse the following link:

http://www.ltcomputerdesigns.com/JCReferences.html

if you've already studied normalization concepts, suggest you post an
explanation of what you're trying to "do" with your database, so we have a
better idea of what suggestions to offer.

hth
 
Back
Top