RE: Is Redundant Data Ok?

From: Nigel Rivett (sqlnr_at_hotmail.com)
Date: 11/07/04 

Date: Sat, 6 Nov 2004 16:10:02 -0800

You have some choices.
You can keep all versions of membership data and have an active flag or a
start/end date on it. In that way the winner data will always be available.

When a member wins then take a copy of the data and save it in the members
table for the winners table to link to.

when a member wins flag the entry as being linked from the winners table -
any changes made then create another version of the entry.

Have an audit trail on the memberst table so that the winners table can
always link to a version of the data.

Reall up to you - think I wouldn't hold the data in the winners table but
maybe another version of the members table so that can have mutiple winner
entries linking to the same members entry.

"Leon" wrote:

> I have two tables one name members and the other name winners. The members
> table hold such information as FirstName, LastName, Email, etc., and the
> winner table hold such information as FirstName, LastName, Email, Prize,
> Address, City, etc. However, as you can see these two table holds pretty
> much the same data, but they are used for two different purposes. The member
> table is use for member registration in which the member can edit there
> personal information on the fly, a member can also be deleted from the
> member table, but the winner table is use for member that have won a prize
> in which winners can never be deleted from this table, information can never
> be edit, the winner table mainly keep a lifelong track second of all past
> and present members ("even if they no longer have a record in the member
> table").
>
> Is it ok to have redundant data in my database in this situation? and is
> this situation pretty common in database design?
>
>
>

Relevant Pages

  • Stewards decisions - Japan 2010
    ... Paul Gutjahr, President of the FIA Hill Climb Commission, member of the board ... of directors and President of Auto Sport Suisse SARL (the FIA delegated ... Radovan Novak, Member of the FIA World Motor Sport Council, Member of the FIA ... former Formula One driver and winner of Le Mans 24 Hours 1996 ...
    (rec.autos.sport.f1)
  • Is Redundant Data Ok?
    ... table is use for member registration in which the member can edit there ... but the winner table is use for member that have won a prize ... be edit, the winner table mainly keep a lifelong track second of all past ... this situation pretty common in database design? ...
    (microsoft.public.sqlserver.programming)
  • Re: The Theory of Evolution is Mathematically Irrational-part 6
    ... generation we choose to call the "progenitors". ... It is a guaranteed outcome, ... For each member of the population, ... extinct before we get a "winner". ...
    (talk.origins)
  • Cruise Giveaway Announcement
    ... Congrats to the winner and I can't wait to see pics and get a review of ... her chosen cruise. ... member and have atleast 10 posts your still in the drawing for next ...
    (rec.travel.cruises)
  • Re: The God Gambit?
    ... operation (formed to beat a legitamate one to a recently sunk ship) is ... a member of their party) walks ashore, he is greeted as a sea god. ... entry for Twain's ACYiKAC for their name for the trope I ...
    (rec.arts.sf.written)