Tag Info

New answers tagged


As datagod points there's a legality component towards the practice of storing sensitive information such as a passport number. Where I live an active enforce of UK law Data protection act is the standard practice. But in other places like Chile is totally legal to store passport number which is the same as the ID (RUN), some websites even offer the ...


When the supplier 'comes back' then do you want to set the EndDate to null again or do you want to keep track of the periods in which the supplier supplied to you? In the last case you must put the StartDate and EndDate in a separate table. If you put it in a separate table then you always must do a join to see if it is an active supplier unless you put an ...

Top 50 recent answers are included