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 -> Re: Help me to design this table

Re: Help me to design this table

From: MD <MD_at_MD.com>
Date: Wed, 30 Aug 2006 18:44:59 GMT
Message-ID: <L0lJg.23249$tP4.6418@clgrps12>


I got it.

Thanks
"EdStevens" <quetico_man_at_yahoo.com> wrote in message news:1156941631.237608.219060_at_i42g2000cwa.googlegroups.com...
>
> 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 - 13:44:59 CDT

Original text of this message

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