i think you may have misunderstood my question( though you also cleared some confusions i had about cascade joins)
let me rephrase my question:
i read some where that :
a sperate relationship table is required for any many to many relationship(which i agree with)
i also read that for a 1:m relationship - if the many entity type is non obligatory you must also define three tables(ie one table for each of the entities and one for the the relationship- this is the table i was referring to, as the join table) -is this true or rather necessary!!!
let me rephrase my question:
i read some where that :
a sperate relationship table is required for any many to many relationship(which i agree with)
i also read that for a 1:m relationship - if the many entity type is non obligatory you must also define three tables(ie one table for each of the entities and one for the the relationship- this is the table i was referring to, as the join table) -is this true or rather necessary!!!