Q:implementation 1:m relation with a bitmap field ?

Sir,
1:m relationship can be implemented with two tables and using joining between parent and child tables.

alternatively, you can denormalied the many(child side) by implementing it as a single column in parent table. for example

      merchant  can conduct business 3 states(1:M)
      can be implemented as
      merchant_id number
      state_cd  varchar2(3) state of tx,mo,ar would be '111'
                            state of tx,   ar would be '101'

Questions,
1. what is pro and cons of implementing denormalized table ? 2. what is performance gains denormalized table vs two table joining ?

Thanks in advance, Ted Chyn

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Sep 09 1999 - 13:55:07 CDT