Forum Replies Created

Viewing 7 posts - 1 through 7 (of 7 total)

  • RE: What is Normal?

    Sergiy (11/28/2016)

    Would you agree with such definition of the surrogate key?

    No I would not a agree, as I already explained.

    November 28, 2016 at 8:42 pm

    #1914858

  • RE: What is Normal?

    Sergiy, your approach seems to amount to "everything is a surrogate". There's no point me disagreeing with that. If that's your opinion then I guess this part of the discussion...

    November 28, 2016 at 3:40 pm

    #1914840

  • RE: What is Normal?

    David.Poole (11/28/2016)

    I think context is all with person records. If you are storing medical procedures to be carried out then you absolutely want to make sure the right person...

    November 28, 2016 at 10:59 am

    #1914792

  • RE: What is Normal?

    Sergiy,

    All data in a database consists of "artificial" symbols assigned by machines or human beings. There are no exceptions. In that very broad sense keys are always surrogates for the...

    November 28, 2016 at 6:28 am

    #1914700

  • RE: What is Normal?

    Sergiy (11/28/2016)

    You must have successfully identified business keys before.

    So it must be easy for you to show couple of examples (from your experience) where natural keys were just right to...

    November 28, 2016 at 5:49 am

    #1914690

  • RE: What is Normal?

    Phil Factor (11/22/2016)

    There's nothing that says a table can't have more than one unique index on it.

    it certainly can. It is no crime but it is a sign...

    November 27, 2016 at 9:20 am

    #1914634

  • RE: What is Normal?

    RonKyle (11/23/2016)

    What is you natural key for "person" records?

    In most cases there isn't one.

    I really have trouble understanding why you would say that. A lot depends on exactly what the...

    November 27, 2016 at 9:13 am

    #1914633

Viewing 7 posts - 1 through 7 (of 7 total)