Re: Help me to design this table

From: MD <MD_at_MD.com>
Date: Tue, 29 Aug 2006 20:54:57 GMT
Message-ID: <BQ1Jg.14804$Nz6.2352@edtnps82>

>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 Received on Tue Aug 29 2006 - 15:54:57 CDT