News for hackers. Stuff that matters.
Re:What does First Normal Form mean? by jraph on Friday June 18, 2021 @11:46AM (#27551568)
What about them? Do they really exist, practically speaking?

At a quick glance on my databases, I see nothing of the sort.

Re:What does First Normal Form mean? by jcranmer on Friday June 18, 2021 @11:57AM (#27551695)
I share the same name and birthdate as another individual. It has actually caused me to be held up at the border before.
Re:What does First Normal Form mean? by jraph on Friday June 18, 2021 @12:00PM (#27551732)
What gave proof that you were not this individual in the end?
Re:What does First Normal Form mean? by ipaddr on Friday June 18, 2021 @10:44PM (#27557291)
But not birth time and birth location.
Re:What does First Normal Form mean? by lkuty on Friday June 18, 2021 @11:49AM (#27551608)
Re:What does First Normal Form mean? by jraph on Friday June 18, 2021 @11:52AM (#27551647)
Is there anything comparable to the birthday paradox, which includes years, by the way?

I would guess that you would need a big group of random people such that there is a high chance of having two people born the very same day.

Re:What does First Normal Form mean? by whatshisface on Friday June 18, 2021 @11:55AM (#27551680)
The birthday paradox threshold if years are included would be 23 people per year, rather than 23 people in your database. What that translates to in your database depends a lot the age demography of your userbase. If people live to be 100, and if I don't worry about the fact that some years will have more people than others even if they are randomly distributed (something that should go in to the model), that's about 2,300 people before you start expecting to see duplicate birthdays.
Re:What does First Normal Form mean? by cyberbanjo on Friday June 18, 2021 @11:53AM (#27551659)
I don't think the birthday problem accounts for year, but yet it's clear some people share the same birthdate, twins for example.
Re:What does First Normal Form mean? by Kranar on Friday June 18, 2021 @12:27PM (#27552026)
Are we seriously discussing whether in practice, two people can be born on the same day?
Re:What does First Normal Form mean? by jraph on Friday June 18, 2021 @06:10PM (#27555544)
This was an absurd joke. A person looking at their database using birth dates as a primary key can obviously only see people with different birth dates.