Re: need help with DB design - trying to reduce duplication
Posted by: Chris Bassett
Date: January 28, 2014 11:58AM

I'm thinking I'll just use a field to determine if the shipping address is active/visible or not (maybe along with a date range).

But in general, how do larger systems work (not neccessarily for this task, but larger databases in general)? Do they just "hide" data from the application (use flags to determine if the data is to be shown or not, or whether it is active or not)? Or do some of them actually delete data when the user indicates that the data is no longer needed and should be deleted?

Options: ReplyQuote


Subject
Written By
Posted
Re: need help with DB design - trying to reduce duplication
January 28, 2014 11:58AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.