Comment

Comment on How does this pic show that Elon Musk doesnt know SQL?

turtle@lemm.ee ⁨5⁩ ⁨days⁩ ago

That all makes sense, except if someone’s SSN changes (which happens under certain circumstances), doesn’t that invalidate their primary key or require a much more complicated operation of issuing a new record and relinking all the existing relationships?

I can imagine an SSN existing in more than one primary key due to errors. If they use SSNs in the primary key at all, but combined with something else, that leads me to believe that the designers felt that SSNs were reliable for being a pure primary key.

I agree with you about Occam’s Razor. The guy has demonstrated multiple times that he’s a dishonest moron.

source

Sort:hotnew top

DahGangalang@infosec.pub ⁨5⁩ ⁨days⁩ ago
I’m not familiar with cases where someone’s SSN could change. Could you link to resources on when that would happen?

source
- turtle@lemm.ee ⁨5⁩ ⁨days⁩ ago
  I don’t have any resources handy, but I do know someone who this happened to: they were an immigrant who got an SSN the first time they migrated to the US, went back to live in their country for a number of years, then returned to the US and I guess applied for an SSN again. Voilá, two SSNs and a mess.
  
  source
  - DahGangalang@infosec.pub ⁨5⁩ ⁨days⁩ ago
    Yeah, I can imagine thats be an administrative headache. I do not envy them the opportunity of sorting that out.
    
    Thanks for the example though. That makes sense.
    
    source
    turtle@lemm.ee ⁨5⁩ ⁨days⁩ ago
    I don’t envy either party either. You’re welcome!
    
    source
spankmonkey@lemmy.world ⁨5⁩ ⁨days⁩ ago

That all makes sense, except if someone’s SSN changes (which happens under certain circumstances), doesn’t that invalidate their primary key or require a much more complicated operation of issuing a new record and relinking all the existing relationships?

Yes, in the case of duplicate SSN assignments l you would need to change their records to align with the new SSN while not changing the records that go the the person who keeps the SSN. We do it with state identifiers and it is a gigantic pain in the ass.

source
- turtle@lemm.ee ⁨5⁩ ⁨days⁩ ago
  I can definitely imagine all that. Thanks!
  
  source