• Im_old@lemmy.world
    link
    fedilink
    arrow-up
    18
    ·
    12 hours ago

    Also that’s not how deduplication works.

    He means/thinks that SSN is not unique (which is not a problem, just different design).

    Of course he’s wrong about lots of stuff, just the nerd in me could not not explain it.

    • dohpaz42@lemmy.world
      link
      fedilink
      English
      arrow-up
      10
      ·
      edit-2
      12 hours ago

      I imagine he’s looking at a payments table where there is a non-unique key to relate a citizen to each payment.

      • Im_old@lemmy.world
        link
        fedilink
        arrow-up
        1
        ·
        7 hours ago

        Yeah, I was thinking something similar. I’m not a DBA but it’s the easiest way (that I can think of) to record all transactions for a certain user.