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!