If I am right [carefully, bax, carefully], what you mean is a sometimes called 'weak entity': an attributed relationship or dependend entity.
I would suggest to dissolve this into one n:1 and one 1:n relation with a third table. This is often used in delivery notes with the delivery date. It is cleaner for the DBMS, n:m does not really exist on physical Level. bax View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3836692#3836692 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3836692 ------------------------------------------------------- This SF.Net email is sponsored by: Oracle 10g Get certified on the hottest thing ever to hit the market... Oracle 10g. Take an Oracle 10g class now, and we'll give you the exam FREE. http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click _______________________________________________ JBoss-Development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
