Normalization

[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 :

 

[tina]

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

 

[Jess Martyn]

Hello,

Recently, http://extremedesigners.5u.com - A website about web designing -
has been launched. I would like you to take a look at it and pass your
suggestions - complements - about it.

- Regards,
Extreme Designing Team.