Re: Normalization
- From: "tina" <nospam@xxxxxxxxxxx>
- Date: Fri, 08 Apr 2005 08:20:25 GMT
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
"jimmy0305" <james.tan@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:x7SdncIJY5-yicvfRVn_vQ@xxxxxxxxxxxxxxx
> 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 not
> 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...Thanks
>
> tblDiagMed
> PatientID
> Mx_ID
> VisitDate
>
> tblDiagMed_Detail
> Meds_ID<---Autonumber
> Mx_ID
> Meds_Code
> Dosage
> Diag_Code
>
> tblDrugs
> Meds_Code
> Desc
> Category_ID
>
> tblDiagnosis
> Diag_Code
> Desc
> Category_ID
>
> Jim :(
>
.
- References:
- Normalization
- From: jimmy0305
- Normalization
- Prev by Date: Re: Still Stuck on Alpha Numerics
- Next by Date: Duplicate values
- Previous by thread: Normalization
- Next by thread: Re: Normalization
- Index(es):
Relevant Pages
|
