With a start and enddate(time) fields





>Hi,
>I have few tables that using surrogate key as primary key. Recently, we have request to enhance our application to support point in time on master table. IOW, each record would have a lifetime.
>
>How should I design my table?
>
>Thank you