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
-----------------------
-----------------------
plant_info
-----------------------
plant_id
plant_name
------------------------
here, i one mol_name is found in more than one plant_name.
the same way, one plant_name has more than one mol_name.
how do i make them one-to-many.
kindly help.
thanks
vijay
---------------------------------
ALL-NEW Yahoo! Messenger - all new features - even more fun!
