Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Help me to design this table

Help me to design this table

From: mich dobelman <sss_at_ddfd.com>
Date: Tue, 29 Aug 2006 08:49:36 GMT
Message-ID: <AcTIg.14748$Nz6.10092@edtnps82>


I am developing web site to compare coupons. we will have all information from yahoo, ecoupon.com and couponshopping.com. The following tables shows the Denny's coupon avaiable from three sites from ecoupon.com you have Free Drink, yahoo 2 for 1, and couponshopping 10% accordingly.

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 |

The problem I am facing now is that what if I add another site handle coupons say EbayCoupon.com
but uses similar id like ec00001. How can I optimize this table so that the data won't be duplicated and normalized for the best performance but still be able to compare the coupons from multiple web sites.

Thanks in advance.

MD Received on Tue Aug 29 2006 - 03:49:36 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US