Re: Help me to design this table

MD wrote:
> >What's the first rule of normalization? Isn't it to eliminate
> >repeating elements? Beyond that, if you are using 'ec00001' to
> >identify a coupon from ecoupon, why would you want to also use it to
> >identify a coupon from EbayCoupon?
>
> Because these coupon ids will be assigned by these coupon issueer not me.
> As far as I know this is only problem. Now I am using coupon id issue from
> each
> coupon issuers as a key( not the primary key ) to identify which coupon is
> coming from which source.
>
> > Shop Master Table
> > | shop_id | ecoupon_id | yahoo_id | couponshopping_id | shop_name |
> > shop_address
> > | 1 | ec00001 | yh00001 | cs00001 |
> > Denny's | 1233 Georgia Ave.
> >
> > Coupon Master Table
> > | id | coupon_id | coupon_content |
> > | 1 | ec00001 | Free Drink |
> > | 2 | yh00001 | 2 For 1 |
> > | 3 | cs00001 | 10% OFF |
>
> MD

Then you have to create your own coupon id that you can guarantee is unique. The vendor supplied id is just a property, dependant on YOUR coupon id. Received on Wed Aug 30 2006 - 07:40:31 CDT