many to many
Posted 20 June 2003 - 02:20 PM
After giving it alot of thought, I don\'t see how to avoid creating many tables, each being a map of many-to-many relationships.
From my understanding, many2many has disadvantages but I\'d like to know why. Can anyone enlighten me so I don\'t regret this strategy.
Using \"1 to many\" will require between 100 and 200 tables so, it doesn\'t appeat to be an elegant solution :?
Posted 21 June 2003 - 05:49 AM
One-to-One relationship can be implemented as a single table and rarely as two tables with primary and foreign key relationships.One-to-Many relationships are implemented by splitting the data into two tables with primary key and foreign key relationships.Many-to-Many relationships are implemented using a junction table with the keys from both the tables forming the composite primary key of the junction table.
It will be a good idea to read up a database designing fundamentals text book.
Posted 21 June 2003 - 05:57 AM
sorry if I wasn\'t being clear on that.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users