nst
04-28-2006, 11:47 AM
We want to build a database where we can store the competitions from our clients. There is one table containing our records which represent competitions & orders. Every record can contain several materials which are being requested in the same competition or order and every material can have multiple companies which are also competing. Meanwhile every material can have a single house from which it is in the end being bought, if we win the competition. But, the same material in another order could be delivered by a different house.
The ER diagram is on the attached picture.
I would appreciate any comments on the structure, before I proceed into the actual coding.
The ER diagram is on the attached picture.
I would appreciate any comments on the structure, before I proceed into the actual coding.