> dear rhino and whil
> thanks for that valuable tip.
> but, dont i have to wory about the repeating id's (are they not
> redundant...) in this table, excuse me if this query looks silly...
>
> PLANT_MOLECULE
> plant_idmolecule_idquantity
> ------
- Original Message -
From: vijaya raj
To: Rhino
Sent: Monday, August 02, 2004 9:31 AM
Subject: Re: help-in-normalizing
dear rhino and whil
thanks for that valuable tip.
but, dont i have to wory about the repeating id's (are they not redundant...) in
this
- Original Message -
From: "vijaya raj" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, August 02, 2004 7:11 AM
Subject: help-in-normalizing
> hi friends
> i am trying to create a data model for my new database.
> i have some problems in norm
> --
> molecule_info
> --
> mol_id
> mol_name
> ---
>
> ---
> plant_info
> ---
> plant_id
> plant_name
>
>
> here, i one mol_name is found in more than one plant_name.
> the
hi friends
i am trying to create a data model for my new database.
i have some problems in normalising my data model.
i have two tables with many-to-many relation.
how to i normalize them to one-to-many form.
--
molecule_info
--
mol_id
mol_name